Which command correctly adds search optimization to a table?

• A. ALTER TABLE my_table ADD SEARCH OPTIMIZATION
• B. ALTER TABLE my_table SET SEARCH OPTIMIZATION
• C. ALTER TABLE my_table SEARCH OPTIMIZATION=TRUE
• D. CREATE SEARCH OPTIMIZATION ON TABLE my_table

Answer: (A)

Search optimization on a table is enabled with an ALTER TABLE statement that adds the optimization. This is the correct syntax because Snowflake provides a specific DDL form to attach search optimization to an existing table: ALTER TABLE ADD SEARCH OPTIMIZATION. It directly creates the optimization structures for that table in one operation. The other styles don’t match Snowflake’s DDL for this feature: SET is used for toggling properties, not for enabling search optimization; the =TRUE form isn’t valid syntax; and creating a separate search optimization object with CREATE is not how you enable it on an existing table.