index hint
Extended SQL syntax for overriding the indexes recommended by the optimizer. For example, the FORCE INDEX
, USE INDEX
, and IGNORE INDEX
clauses. Typically used when indexed columns have unevenly distributed values, resulting in inaccurate cardinality estimates.
See also cardinality.
See also index.