Home | Previous Page | Next Page   System Catalog Tables >

SYSDIRECTIVES (IDS)

The sysdirectives table stores external optimizer directives that can be applied to queries. Whether queries in client applications can use these optimizer directives depends on the setting of the IFX_EXTDIRECTIVES environment variable on the client system, as described in Chapter 3, and on the EXT_DIRECTIVES setting in the configuration file of the database server.

The sysdirectives table has the following columns.

Column Type Explanation
id SERIAL Unique code identifying the optimizer directive
query TEXT Text of the query as it appears in the application
directives TEXT Text of the optimizer directive, without comments
active SMALLINT Integer code that identifyies whether this entry is active ( = 1 ) or test only ( = 2 )
hash_code SMALLINT For internal use only

NULL values are not valid in the query column. There is a unique index on the id column.

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