FIXED TABLE (FIXED INDEX)

Description

Access a fixed (X$) table using an indexed column

Versions

This operation was introduced in Oracle 9.0.1

This operation is implemented in the following versions

Example

Example 1

This example must be run by the SYS user due to restrictions on the use of EXPLAIN for X$ tables.

This example was developed using Oracle 9.2.0.1 on Windows 2000

The statement

    SELECT * FROM x$ksuse WHERE indx = 0;

generates the following execution plan

0     SELECT STATEMENT Optimizer=CHOOSE
1   0   FIXED TABLE (FIXED INDEX) OF 'X$KSUSE' (ind:1)

Example 2

This example must be run by the SYS user due to restrictions on the use of EXPLAIN for X$ tables.

This example was developed using Oracle 9.2.0.1 on Windows 2000

The statement

    SELECT * FROM x$ksumysta WHERE indx = 0;

generates the following execution plan

0     SELECT STATEMENT Optimizer=CHOOSE
1   0   FIXED TABLE (FIXED INDEX) OF 'X$KSUMYSTA' (ind:2)

Example 3

This example must be run by the SYS user due to restrictions on the use of EXPLAIN for X$ tables.

This example was developed using Oracle 9.2.0.1 on Windows 2000

The statement

    SELECT * FROM x$ksumysta WHERE ksusestn = 0;

generates the following execution plan

0     SELECT STATEMENT Optimizer=CHOOSE
1   0   FIXED TABLE (FIXED INDEX) OF 'X$KSUMYSTA' (ind:3)