Earlier chapters discussed clustering, materialized views, dynamic tables, and the Query Acceleration Service (QAS). In this chapter I cover the Search Optimization Service (SOS) as an alternative but complementary approach.
At a fundamental level, query optimization resolves micro-partition pruning to reduce the number of micro-partitions accessed for queries. Viewed from a pure micro-partition pruning perspective, without considering summaries and aggregates, SOS adopts a different approach to enable ...
