Home | Previous Page | Next Page   Descriptor Function Reference > Accessor Functions >

mi_qual_setreopt()

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 index.

If the access method sets mi_qual_setreopt(), the database server invokes the am_scancost purpose function before the next scan.

Return Values

None

Related Topics

See the descriptions of:

Home | [ Top of Page | Previous Page | Next Page | Contents | Index ]