home - keyword index

Table: USER_INDEXES

Description of the user's own indexes

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

home - keyword index

Comment on this page: