How can performance be optimized for a query that returns a small amount of data from a very large base table?
How can performance be optimized for a query that returns a small amount of data from a very large base table?
To optimize performance for a query that returns a small amount of data from a very large base table, using the search optimization service is the most effective approach. The search optimization service improves performance for selective point lookup queries, which return only a small number of distinct rows. This is particularly beneficial for scenarios requiring fast response times on highly selective filters or retrieving small subsets of data from large datasets.
C https://docs.snowflake.com/en/user-guide/search-optimization-service#:~:text=Selective%20point%20lookup%20queries%20on%20tables.%20A%20point%20lookup%20query%20returns%20only%20one%20or%20a%20small%20number%20of%20distinct%20rows
"The search optimization service aims to significantly improve the performance of certain types of queries on tables, including: Selective point lookup queries on tables. A point lookup query returns only one or a small number of distinct rows. Use case examples include: Business users who need fast response times for critical dashboards with highly selective filters. Data scientists who are exploring large data volumes and looking for specific subsets of data. Data applications retrieving a small set of results based on an extensive set of filtering predicates."
It's C : https://docs.snowflake.com/en/user-guide/search-optimization-service