Which statement describes the best practice when adding search optimization to a table?

• A. Register all tables in a schema to search optimization.
• B. Before adding search optimization to a large table, get an estimate of costs involved.
• C. Batching of DML operations on the table.
• D. The table should not be clustered or the clustering key is different from the columns frequently used in queries.

Answer: (A)

Registering all tables in a schema to search optimization is the best practice because it ensures every table can benefit from accelerated searches without needing manual, per-table decisions. The Search Optimization Service builds and maintains optimized data structures for each table to speed up text and pattern-match queries. Applying SOS to the entire schema avoids gaps where a new or overlooked table would miss optimization, keeps performance consistent across the schema, and reduces ongoing administrative effort since future tables in that schema are automatically covered. While evaluating costs before enabling on a large table can be wise in some scenarios, broad coverage provides the most reliable and scalable performance gains.