When using Search Optimization, if table data is updated what happens?

• A. The maintenance service automatically updates the search access path to reflect changes to the data
• B. The search access path remains unchanged until you rebuild it
• C. The data is flagged for indexing
• D. The system disables the optimization temporarily

Answer: (A)

Search Optimization keeps data quickly accessible by maintaining a dedicated search access path that the query engine uses for fast lookups. When you update data in a table, the maintenance service automatically refreshes that search access path to reflect the new state, so you don’t have to manually rebuild anything. This incremental maintenance ensures queries continue to benefit from optimized access even as data changes. The other options—rebuilding the path manually, flagging data for indexing, or disabling optimization—don’t fit how this feature operates, since the system is designed to automatically keep the access path in sync with updates.