Input tables

Db2-supplied user input tables enable you to provide certain types of information, such as performance tuning information, to Db2.

DSN_VIRTUAL_INDEXES
The virtual indexes table, DSN_VIRTUAL_INDEXES, enables optimization tools to test the effect of creating and dropping indexes on the performance of particular queries.
DSN_VIRTUAL_KEYTARGETS
The DSN_VIRTUAL_KEYTARGETS table contains information about expression-based indexes and XML indexes.
DSN_USERQUERY_TABLE
The DSN_USERQUERY_TABLE table identifies statements whose access paths are influenced. The values identify the statements and the method that is used to influence access path selection. Values in the DSN_USERQUERY_TABLE are used to populate certain catalog tables when a BIND QUERY command is issued.

Parent topic: Db2-supplied user tables