AI Features

enable_hypo_index

Parameter description: Specifies whether the database optimizer considers the created virtual index when executing the EXPLAIN statement. By executing EXPLAIN on a specific query statement, you can evaluate whether the index can improve the execution efficiency of the query statement based on the execution plan provided by the optimizer.

This is a USERSET parameter. Set it based on instructions provided in Table 2.

Value range: Boolean

• on indicates that a virtual index is created during EXPLAIN execution.
• off indicates that no virtual index is created during EXPLAIN execution.

Default value: off