The mi_qual_setreopt() accessor function
The mi_qual_setreopt() function sets an indicator in the qualification descriptor to force reoptimization.
Syntax
void mi_qual_setreopt(MI_AM_QUAL_DESC *qualDesc)- qualDesc
- Points to the qualification descriptor.
Usage
The am_scancost purpose function can call the mi_qual_setreopt() to indicate that the optimizer should reevaluate the query path between scans. For example, if either the mi_qual_const_depends_hostvar() or mi_qual_const_depends_outer() function returns MI_TRUE, the access method can call mi_qual_setreopt() to alert the optimizer that the constant-argument value in a qualification descriptor might change between scans on the same table.
If the access method sets mi_qual_setreopt(), the database server invokes the am_scancost purpose function before the next scan.
Return values
None