Which privilege is required on the table to use the Search Optimization Service for a query?

• A. OWNERSHIP on the table
• B. SELECT on the table
• C. ADD SEARCH OPTIMIZATION on the schema
• D. USAGE on the schema

Answer: (B)

Access to read the table data is what lets the Search Optimization Service speed up a query. The service enhances how data is scanned during a SELECT by using optimized structures, but it can only apply when the engine is allowed to read the table. Having the ability to read the table—granted by the SELECT privilege on that table—provides the necessary access without giving broader rights. Granting a schema-level privilege to add Search Optimization isn’t about reading the data for a specific query, and USAGE on the schema doesn’t permit data access. So, the required privilege is the SELECT on the table.