Answer: Use the search optimization service

The search optimization service (option C) is specifically designed to optimize queries that return small result sets from large tables, particularly selective point lookup queries that return only one or a few distinct rows. This service automatically creates and maintains optimized data structures to accelerate such queries without manual intervention. While clustering keys (A) can help with range queries and materialized views (B) can precompute results, they require more manual configuration and maintenance. The query acceleration service (D) is better suited for complex analytical queries involving large result sets, not small selective lookups. The community discussion shows 100% consensus on option C, with multiple comments citing Snowflake documentation that specifically mentions this use case for the search optimization service.

Author: LeetQuiz Editorial Team