Get a specific index
get
/database/objects/indexes/{owner},{index_name}
Returns the corresponding record from DBA_INDEXES or ALL_INDEXES view depending on role at runtime. A client requires SQL Administrator or SQL Developer role to invoke this service.
Request
Path Parameters
-
index_name(required): string
Name of the index.
-
owner(required): string
Owner for the index.
There's no request body for this operation.
Back to TopResponse
Supported Media Types
- application/json
200 Response
Information on a specific index.
Root Schema : DatabaseObjectsIndexesItem
Type:
object
Describes an index in the database.
Show Source
-
avg_data_blocks_per_key: integer
Average number of data blocks in the table that are pointed to by a distinct value in the index rounded to the nearest integer.
-
avg_leaf_blocks_per_key: integer
Average number of leaf blocks in which each distinct value in the index appears, rounded to the nearest integer.
-
blevel: integer
B*-Tree level (depth of the index from its root block to its leaf blocks). A depth of 0 indicates that the root block and leaf block are the same.
-
buffer_pool: string
Buffer pool to be used for index blocks.
-
cell_flash_cache: string
Cell flash cache hint to be used for index blocks.
-
clustering_factor: number
Indicates the amount of order of the rows in the table based on the values of the index.
-
compression: string
The type of compression being used for the index.
-
degree: string
Number of threads per instance for scanning the index, or DEFAULT.
-
distinct_keys: integer
Number of distinct indexed values.
-
domidx_management: string
If this is a domain index, indicates whether the domain index is system-managed (SYSTEM_MANAGED) or user-managed (USER_MANAGED).
-
domidx_opstatus: string
Status of the operation on a domain index.
-
domidx_status: string
Status of a domain index.
-
dropped: string
Indicates whether redundant primary key columns are eliminated from secondary indexes on index-organized tables (YES) or not (NO).
-
duration: string
Indicates the duration of a temporary table.
-
flash_cache: string
Database Smart Flash Cache hint to be used for index blocks.
-
freelist_groups: integer
Number of freelist groups allocated to this segment.
-
freelists: integer
Number of process freelists allocated to this segment.
-
funcidx_status: string
Status of a function-based index.
-
generated: string
Indicates whether the name of the index is system-generated (Y) or not (N).
-
global_stats: string
GLOBAL_STATS will be YES if statistics are gathered or incrementally maintained, otherwise it will be NO.
-
include_column: integer
Column ID of the last column to be included in index-organized table primary key (non-overflow) index.
-
index_name: string
Name of the index.
-
index_type: string
Type of the index.
-
indexing: string
Indicates whether a global index is decoupled from the underlying table.
-
ini_trans: integer
Initial number of transactions.
-
initial_extent: integer
Size of the initial extent.
-
instances: string
Number of instances across which the indexes to be scanned, or DEFAULT.
-
iot_redundant_pkey_elim: string
Indicates whether redundant primary key columns are eliminated from secondary indexes on index-organized tables (YES) or not (NO).
-
ityp_name: string
For a domain index, the name of the indextype.
-
ityp_owner: string
For a domain index, the owner of the indextype.
-
join_index: string
Indicates whether the index is a join index (YES) or not (NO).
-
last_analyzed: string
Date on which this index was most recently analyzed.
-
leaf_blocks: integer
Number of leaf blocks in the index.
-
links: array
links
-
logging: string
Indicates whether or not changes to the index are logged.
-
max_extents: integer
Maximum number of extents allowed in the segment.
-
max_trans: integer
Maximum number of transactions.
-
min_extents: integer
Minimum number of extents allowed in the segment.
-
next_extent: integer
Size of secondary extents.
-
num_rows: integer
Number of rows in the index.
-
orphaned_entries: string
Indicates whether a global index contains stale entries because of deferred index maintenance during DROP/TRUNCATE PARTITION, or MODIFY PARTITION INDEXING OFF operations.
-
owner: string
Owner of the index.
-
parameters: string
For a domain index, the parameter string.
-
partitioned: string
Indicates whether the index is partitioned (YES) or not (NO).
-
pct_direct_access: number
For a secondary index on an index-organized table, the percentage of rows with VALID guess.
-
pct_free: integer
Minimum percentage of free space in a block.
-
pct_increase: number
Percentage increase in extent size.
-
pct_threshold: number
Threshold percentage of block space allowed per index entry.
-
prefix_length: integer
Number of columns in the prefix of the compression key.
-
sample_size: integer
Size of the sample used to analyze the index.
-
secondary: string
Indicates whether the index is a secondary object created by the ODCIIndexCreate method of the Oracle Data Cartridge (Y) or not (N).
-
segment_created: string
Indicates whether the index segment has been created (YES) or not (NO).
-
status: string
Indicates whether a nonpartitioned index is VALID or UNUSABLE.
-
table_name: string
Name of the indexed object.
-
table_owner: string
Owner of the indexed object.
-
table_type: string
Type of the indexed object.
-
tablespace_name: string
Name of the tablespace containing the index.
-
temporary: string
Indicates whether the index is on a temporary table (Y) or not (N).
-
uniqueness: string
Indicates whether the index is unique (UNIQUE) or nonunique (NONUNIQUE).
-
user_stats: string
Indicates whether statistics were entered directly by the user (YES) or not (NO).
-
visibility: string
Indicates whether the index is VISIBLE or INVISIBLE to the optimizer.