SET INDEX

Enterprise Edition Home | Express Edition Home | Previous Page | Next Page SQL Statements >

SET INDEX

Use the SET INDEX statement to specify that one or more fragments of an index be resident in shared memory as long as possible. Only Extended Parallel Server supports this statement, which is an extension to the ANSI/ISO standard for SQL.

Syntax

>>-SET INDEX--index--+-------------------+---------------------->
                     |    .-,-------.    |
                     |    V         |    |
                     '-(----dbspace-+--)-'
 
>--+-MEMORY_RESIDENT-+-----------------------------------------><
   '-NON_RESIDENT----'

Element	Description	Restrictions	Syntax
dbspace	Dbspace in which to store the fragment	Must exist	Identifier, p. Identifier
index	Index for which to change residency state	Must exist	Database Object Name, p. Database Object Name

Usage

This statement was formerly supported by Dynamic Server, but it is ignored in current releases. Beginning with Version 9.40, Dynamic Server determines the residency status of indexes and tables automatically.

The SET INDEX statement is a special case of the SET Residency statement. The SET Residency statement can also specify how long a table fragment remains resident in shared memory.

For the complete syntax and semantics of the SET INDEX statement, see SET Residency .