Access a fixed (X$) table using index column 3
This operation was desupported in Oracle 9.0.1
This operation is implemented in the following versions
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 8.1.7
SELECT * FROM x$ksumysta WHERE ksusestn = 0;
generates the following execution plan
0 SELECT STATEMENT Optimizer=CHOOSE 1 0 FIXED TABLE (FIXED INDEX #3) OF 'X$KSUMYSTA'