Which SQL statement removes search optimization from a table?

• A. ALTER TABLE [IF EXISTS] <table_name> drop SEARCH OPTIMIZATION;
• B. ALTER TABLE [IF EXISTS] <table_name> disable SEARCH OPTIMIZATION;
• C. ALTER TABLE [IF EXISTS] <table_name> remove SEARCH OPTIMIZATION;
• D. ALTER TABLE [IF EXISTS] <table_name> stop SEARCH OPTIMIZATION;

Answer: (A)

Search optimization is an optional enhancement you can apply to a table to speed up certain search queries. To remove that enhancement, you use the DROP form of the ALTER TABLE statement. The valid way to do this is:

ALTER TABLE [IF EXISTS] DROP SEARCH OPTIMIZATION;

This directly signals the system to remove the search optimization from the table. Other verbs like disable, remove, or stop don’t correspond to the supported syntax for this feature, so they aren’t valid ways to drop the optimization.