ALL_INDEXES

Columns
   ___________________________
 
   LOGGING
      Logging attribute
   PCT_INCREASE
      Percentage increase in extent size
   MIN_EXTENTS
      Minimum number of extents allowed in the segment
   PCT_THRESHOLD
      Threshold percentage of block space allowed per index entry
   MAX_EXTENTS
      Maximum number of extents allowed in the segment
   INCLUDE_COLUMN
      User column-id for last column to be included in index-organized table top index
   FREELISTS
      Number of process freelists allocated in this segment
   NEXT_EXTENT
      Size of secondary extents
   PCT_FREE
      Minimum percentage of free space in a block
   TABLE_NAME
      Name of the indexed object
   BLEVEL
      B-Tree level
   LEAF_BLOCKS
      The number of leaf blocks in the index
   FREELIST_GROUPS
      Number of freelist groups allocated to this segment
   INITIAL_EXTENT
      Size of the initial extent
   MAX_TRANS
      Maximum number of transactions
   INI_TRANS
      Initial number of transactions
   OWNER
      Username of the owner of the index
   INDEX_NAME
      Name of the index
   TABLE_OWNER
      Owner of the indexed object
   TABLE_TYPE
      Type of the indexed object
   DURATION
      If index on temporary table, then duration is sys$session or sys$transaction else NULL
   TABLESPACE_NAME
      Name of the tablespace containing the index
   PREFIX_LENGTH
      Number of key columns in the prefix used for compression
   COMPRESSION
      Compression property of the index: `ENABLED`,  `DISABLED`, or NULL
   UNIQUENESS
      Uniqueness status of the index: `UNIQUE`,  `NONUNIQUE`, or `BITMAP`
   DISTINCT_KEYS
      The number of distinct keys in the index
   INDEX_TYPE
   BUFFER_POOL
      The default buffer pool to be used for index blocks
   FUNCIDX_STATUS
      Is the Function-based Index DISABLED or ENABLED?
   DOMIDX_OPSTATUS
      Status of the operation on the domain index
   DOMIDX_STATUS
      Is the indextype of the domain index valid
   PARAMETERS
      If domain index, then this is the parameter string
   ITYP_NAME
      If domain index, then this is the name of the associated indextype
   ITYP_OWNER
      If domain index, then this is the indextype owner
   PCT_DIRECT_ACCESS
      If index on IOT, then this is percentage of rows with Valid guess
   GLOBAL_STATS
      Are the statistics calculated without merging underlying partitions?
   USER_STATS
      Were the statistics entered directly by the user?
   AVG_LEAF_BLOCKS_PER_KEY
      The average number of leaf blocks per key
   SECONDARY
      Is the index object created as part of icreate for domain indexes?
   NUM_ROWS
   AVG_DATA_BLOCKS_PER_KEY
      The average number of data blocks per key
   STATUS
      Whether the non-partitioned index is in USABLE or not
   GENERATED
      Was the name of this index system generated?
   SAMPLE_SIZE
      The sample size used in analyzing this index
   LAST_ANALYZED
      The date of the most recent time this index was analyzed
   DEGREE
      The number of threads per instance for scanning the partitioned index
   INSTANCES
      The number of instances across which the partitioned index is to be scanned
   PARTITIONED
      Is this index partitioned? YES or NO
   TEMPORARY
      Can the current session only see data that it place in this object itself?
   CLUSTERING_FACTOR
      A measurement of the amount of (dis)order of the table this index is for

Related Commands: