Tables for influencing access path selection

Certain tables provide input for or contain the output when you issue BIND QUERY commands to influence access path selection for matching SQL statements.

You can use the following methods to influence access path selection for matching SQL statements:

Overriding the selectivities of predicates.
Specifying statement-level optimization parameters.
Specifying statement level access paths.

Only certain tables are used, depending on the methods that you specify in the input tables.

Tables that are used for BIND QUERY input

The following tables provide input for the bind query command. The tables that you populate depend on the method that you use to influence access path selection:

DSN_USERQUERY_TABLE
PLAN_TABLE
DSN_PREDICAT_TABLE
DSN_PREDICATE_SELECTIVITY table

Catalog tables that BIND QUERY commands populate

The following tables are populated by the BIND QUERY depending on the method for influencing access path selection that you specify in the input tables:

SYSQUERY catalog table
SYSQUERYOPTS catalog table
SYSQUERYPLAN catalog table
SYSQUERYPREDICATE catalog table
SYSQUERYSEL catalog table