Optimizing Extensible Query

About Extensible Query Optimizer

The Extensible Query Optimizer (EQO) provides extended functionality for optimizing the execution of text queries. EQO allows you to define the statistics collection, selectivity and cost functions for text (domain) indexes. The EQO then chooses a query plan based on these statistics, selectivity and cost.
This task explains how to optimize the query:
  1. From the navigation pad, select Tools >Text Management > Extensible Query Optimizer. The Extensible Query Optimizer page appears.
     

  2. You can use the EQO for these options:

    Enable the Extensible Query Optimizer.

    Disable the Extensible Query Optimizer.

    Note: The Extensible Query Optimizer is enabled by default.

  3. To enable the EQO, select the Enable Extensible Query Optimizer option and click Execute. When you enable the EQO, the statistics are associated with the context index type and the ctx_contains package. After enabling the EQO, you need to collect the statistics for your text indexes.

  4. To disable the EQO, select the Disable Extensible Query Optimizer option and click Execute. When you disable the EQO, the statistics on the text indexes are removed and the statistics from the context index type and the ctx_contains package are disassociated.

    The text search performance might improve drastically when the EQO is disabled. We recommend that you disable the EQO when you observe slow performance with the text search.