How can you verify that search optimization is enabled on a table?

• A. Check table size
• B. Verify by checking that SEARCH_OPTIMIZATION equals ON
• C. Run a simple query only
• D. Check user privileges

Answer: (B)

Search optimization is controlled at the table level, and its status is stored in the table’s metadata. To verify it’s enabled, you check that metadata and look for the setting, which should show as ON when SOS is active for that table. In practice, you’d query the catalog (for example, a SHOW TABLES result or a DESCRIBE-like view) and confirm that the table’s SEARCH_OPTIMIZATION value is ON. If it’s ON, search optimization is enabled for that table; if not, it isn’t. Other checks like table size, running a simple query, or inspecting privileges don’t indicate whether search optimization is turned on.