
Answer-first summary for fast verification
Answer: Search optimization service
The Search Optimization Service is specifically designed to improve the performance of point lookup queries, which are queries that retrieve specific, individual rows based on equality predicates. This service creates and maintains additional metadata structures that enable faster access to individual rows without requiring full table scans. Materialized views (A) are better for pre-computing complex aggregations, automatic clustering (B) optimizes data organization for range queries, and query acceleration service (C) handles resource-intensive analytical queries rather than point lookups. The community discussion shows 100% consensus on option D with upvoted confirmation that it's correct.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
No comments yet.