FIXED TABLE (FULL)

Description

Equivalent of a full table scan for an X$ table

Versions

This operation is implemented in the following versions

Example

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

The statement

    SELECT COUNT(*) FROM x$kqfta

generates the following execution plan

0     SELECT STATEMENT Optimizer=CHOOSE
1   0   SORT (AGGREGATE)
2   1     FIXED TABLE (FULL) OF 'X$KQFTA'