Description of the user's own indexes
Columns ___________________________ INDEX_NAME Name of the index INDEX_TYPE -- TABLE_OWNER Owner of the indexed object TABLE_NAME Name of the indexed object TABLE_TYPE Type of the indexed object UNIQUENESS Uniqueness status of the index: "UNIQUE","NONUNIQUE",or "BITMAP" COMPRESSION Compression property of the index: "ENABLED","DISABLED",or NULL PREFIX_LENGTH Number of key columns in the prefix used for compression TABLESPACE_NAME Name of the tablespace containing the index INI_TRANS Initial number of transactions MAX_TRANS Maximum number of transactions INITIAL_EXTENT Size of the initial extent in bytes NEXT_EXTENT Size of secondary extents in bytes MIN_EXTENTS Minimum number of extents allowed in the segment MAX_EXTENTS Maximum number of extents allowed in the segment PCT_INCREASE Percentage increase in extent size PCT_THRESHOLD Threshold percentage of block space allowed per index entry INCLUDE_COLUMN User column-id for last column to be included in index-only table top index FREELISTS Number of process freelists allocated in this segment FREELIST_GROUPS Number of freelist groups allocated to this segment PCT_FREE Minimum percentage of free space in a block LOGGING Logging attribute BLEVEL B-Tree level LEAF_BLOCKS The number of leaf blocks in the index DISTINCT_KEYS The number of distinct keys in the index AVG_LEAF_BLOCKS_PER_KEY The average number of leaf blocks per key AVG_DATA_BLOCKS_PER_KEY The average number of data blocks per key CLUSTERING_FACTOR A measurement of the amount of (dis)order of the table this index is for STATUS Whether the non-partitioned index is in USABLE or not NUM_ROWS Number of rows in the index 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? GENERATED Was the name of this index system generated? SECONDARY Is the index object created as part of icreate for domain indexes? BUFFER_POOL The default buffer pool to be used for index blocks USER_STATS Were the statistics entered directly by the user? DURATION If index on temporary table,then duration is sys$session or sys$transaction else NULL PCT_DIRECT_ACCESS If index on IOT,then this is percentage of rows with Valid guess ITYP_OWNER If domain index,then this is the indextype owner ITYP_NAME If domain index,then this is the name of the associated indextype PARAMETERS If domain index,then this is the parameter string GLOBAL_STATS Are the statistics calculated without merging underlying partitions? DOMIDX_STATUS Is the indextype of the domain index valid DOMIDX_OPSTATUS Status of the operation on the domain index FUNCIDX_STATUS Is the Function-based Index DISABLED or ENABLED? JOIN_INDEX Is this index a join index?