True or False: Search Optimization is a table-level property?

• A. True
• B. False
• C. Partially
• D. Not applicable

Answer: (A)

Search Optimization is configured for individual tables to speed up certain queries by guiding how Snowflake scans data in that table. Because the setting lives in the table’s metadata and is applied on a per-table basis, it is a table-level property. You enable it on specific tables that would benefit from faster point lookups or range scans, while other tables can remain unaffected. This selective applicability is why the statement is true: the optimization is not a global database or warehouse setting, nor is it something that applies automatically to all data. In practice, you’d enable it on large or frequently queried tables after evaluating the performance gains, keeping the rest of your tables as-is.