What persistent data structures are used by the search optimization service to improve the performance of point lookups?
What persistent data structures are used by the search optimization service to improve the performance of point lookups?
To improve the performance of point lookups, the search optimization service uses persistent data structures called search access paths. These structures keep track of which values of the table's columns might be found in each of its micro-partitions, enabling more efficient scanning by allowing some micro-partitions to be skipped.
To improve performance of search queries, the search optimization service creates and maintains a persistent data structure called a search access path. The search access path keeps track of which values of the table’s columns might be found in each of its micro-partitions, allowing some micro-partitions to be skipped when scanning the table.
https://docs.snowflake.com/en/user-guide/search-optimization-service#how-the-search-optimization-service-works