ALL_INDEXES

Previous Next JavaScript must be enabled to correctly display this content

C.9 ALL_INDEXES

ALL_INDEXES data dictionary for Oracle Database Gateway for SQL Server.

Name	Type	Value
`OWNER`	`VARCHAR2(256)`	-
`INDEX_NAME`	`VARCHAR2(256)`	-
`INDEX_TYPE`	`VARCHAR2(1)`	`NULL`
`TABLE_OWNER`	`VARCHAR2(256)`	-
`TABLE_NAME`	`VARCHAR2(256)`	-
`TABLE_TYPE`	`VARCHAR(7)`	"`TABLE`" or "`CLUSTER`"
`UNIQUENESS`	`VARCHAR2(1)`	`NULL`
`COMPRESSION`	`VARCHAR2(1)`	`NULL`
`PREFIX_LENGTH`	`NUMBER`	`0`
`TABLESPACE_NAME`	`VARCHAR2(1)`	`NULL`
`INI_TRANS`	`NUMBER`	`0`
`MAX_TRANS`	`NUMBER`	`0`
`INITIAL_EXTENT`	`NUMBER`	`0`
`NEXT_EXTENT`	`NUMBER`	`0`
`MIN_EXTENTS`	`NUMBER`	`0`
`MAX_EXTENTS`	`NUMBER`	`0`
`PCT_INCREASE`	`NUMBER`	`0`
`PCT_THRESHOLD`	`NUMBER`	`0`
`INCLUDE_COLUMN`	`NUMBER`	`0`
`FREELISTS`	`NUMBER`	`0`
`FREELIST_GROUPS`	`NUMBER`	`0`
`PCT_FREE`	`NUMBER`	`0`
`LOGGING`	`VARCHAR2(1)`	`NULL`
`BLEVEL`	`NUMBER`	`0`
`LEAF_BLOCKS`	`NUMBER`	`0`
`DISTINCT_KEYS`	`NUMBER`	`0`
`AVG_LEAF_BLOCKS_PER_KEY`	`NUMBER`	`0`
`AVG_DATA_BLOCKS_PER_KEY`	`NUMBER`	`0`
`CLUSTERING_FACTOR`	`NUMBER`	`0`
`STATUS`	`VARCHAR2(1)`	`NULL`
`NUM_ROWS`	`NUMBER`	`0`
`SAMPLE_SIZE`	`NUMBER`	`0`
`LAST_ANALYZED`	`DATE`	`NULL`
`DEGREE`	`VARCHAR2(1)`	`NULL`
`INSTANCES`	`VARCHAR2(1)`	`NULL`
`PARTITIONED`	`VARCHAR2(1)`	`NULL`
`TEMPORARY`	`VARCHAR2(1)`	`NULL`
`GENERATED`	`VARCHAR2(1)`	`NULL`
`SECONDARY`	`VARCHAR2(1)`	`NULL`
`BUFFER_POOL`	`VARCHAR2(1)`	`NULL`
`USER_STATS`	`VARCHAR2(1)`	`NULL`
`DURATION`	`VARCHAR2(1)`	`NULL`
`PCT_DIRECT_ACCESS`	`NUMBER`	`0`
`ITYP_OWNER`	`VARCHAR2(1)`	`NULL`
`ITYP_NAME`	`VARCHAR2(1)`	`NULL`
`PARAMETERS`	`VARCHAR2(1)`	`NULL`
`GLOBAL_STATS`	`VARCHAR2(1)`	`NULL`
`DOMIDX_STATUS`	`VARCHAR2(1)`	`NULL`
`DOMIDX_OPSTATUS`	`VARCHAR2(1)`	`NULL`
`FUNCIDX_STATUS`	`VARCHAR2(1)`	`NULL`

Parent topic: Data Dictionary