When adding search optimization to a table, what occurs?

• A. Maintenance service creates and populates the search access path with data needed to perform lookups
• B. The table is rebuilt
• C. Nothing happens automatically
• D. It creates an external index

Answer: (A)

When you add search optimization, Snowflake triggers a background process to build a specialized structure called the search access path and fill it with the data needed for fast lookups. This maintenance service creates and populates that path so subsequent queries can quickly locate rows without scanning the whole table. It’s not a full table rebuild, nor an external index, and the path is kept up to date automatically as data changes.