page169
255
SELECT system$estimate_search_optimization_costs
( 'tpc.tpc_owner.lineitem_baseline' );
Figure 7-3 shows the
StorageCosts
“value” populated indicating the Snowflake
SOS background service has completed. A value of 0 indicated the Snowflake SOS
background service is in the process of executing.
Figure 7-3.
Search optimization enabled
You can find more information on search optimization at
https://docs.
snowflake.com/en/sql-reference/sql/alter-table#label-alter-table-
searchoptimizationaction
.
You can investigate how search optimization has been applied to a table.
DESCRIBE SEARCH OPTIMIZATION ON tpc.tpc_owner.lineitem_baseline;
As the partial screenshot shown in Figure 7-4 illustrates, all table attributes are
shown as “active” with the method
EQUALITY
.
Figure 7-4.
Table search optimization results
Chapter 7
SearCh OptimizatiOn ServiCe