Which of the following operations updates the search access path automatically?

• A. The new column is automatically added to the search access path
• B. The search access path becomes invalid
• C. Renaming a column requires manual update
• D. Changing table schema automatically disables search optimization

Answer: (A)

When search optimization is active, the system keeps a search access path that mirrors the table’s columns. Adding a new column automatically extends that path, so the optimizer can use the new column in predicate-based pruning without any manual edits. This automatic inclusion makes queries faster right away and reduces maintenance.

Renaming a column isn’t handled automatically by the path because the path references the column’s identifier; you’d need to update it to reflect the new name. Changing the table schema can affect optimization and may require re-evaluation or re-enabling, but it isn’t guaranteed to disable optimization automatically.