Columnas
Detalles
Estadísticas
Particiones
Columnas
Detalles
Estadísticas
Particiones
INDEX_OWNER | INDEX_NAME | TABLE_OWNER | TABLE_NAME | COLUMN_NAME | COLUMN_POSITION | DESCEND |
---|---|---|---|---|---|---|
CARTERAINVERSION_USER | ORDENINVERSION__IDXV1 | CARTERAINVERSION_USER | ORDENINVERSION | ESTADOID | 1 | ASC |
NAME | VALUE |
---|---|
CREATED | 11/06/15 |
LAST_DDL_TIME | 11/06/15 |
OWNER | CARTERAINVERSION_USER |
INDEX_NAME | ORDENINVERSION__IDXV1 |
INDEX_TYPE | NORMAL |
TABLE_OWNER | CARTERAINVERSION_USER |
TABLE_NAME | ORDENINVERSION |
TABLE_TYPE | TABLE |
UNIQUENESS | NONUNIQUE |
COMPRESSION | DISABLED |
PREFIX_LENGTH | null |
TABLESPACE_NAME | CARTERAINVERSION |
INI_TRANS | 2 |
MAX_TRANS | 255 |
INITIAL_EXTENT | 65536 |
NEXT_EXTENT | 1048576 |
MIN_EXTENTS | 1 |
MAX_EXTENTS | 2147483645 |
PCT_INCREASE | null |
PCT_THRESHOLD | null |
INCLUDE_COLUMN | null |
FREELISTS | null |
FREELIST_GROUPS | null |
PCT_FREE | 10 |
LOGGING | YES |
BLEVEL | 0 |
LEAF_BLOCKS | 0 |
DISTINCT_KEYS | 0 |
AVG_LEAF_BLOCKS_PER_KEY | 0 |
AVG_DATA_BLOCKS_PER_KEY | 0 |
CLUSTERING_FACTOR | 0 |
STATUS | VALID |
NUM_ROWS | 0 |
SAMPLE_SIZE | 0 |
LAST_ANALYZED | 11/06/15 |
DEGREE | 1 |
INSTANCES | 1 |
PARTITIONED | NO |
TEMPORARY | N |
GENERATED | N |
SECONDARY | N |
BUFFER_POOL | DEFAULT |
FLASH_CACHE | DEFAULT |
CELL_FLASH_CACHE | DEFAULT |
USER_STATS | NO |
DURATION | null |
PCT_DIRECT_ACCESS | null |
ITYP_OWNER | null |
ITYP_NAME | null |
PARAMETERS | null |
GLOBAL_STATS | NO |
DOMIDX_STATUS | null |
DOMIDX_OPSTATUS | null |
FUNCIDX_STATUS | null |
JOIN_INDEX | NO |
IOT_REDUNDANT_PKEY_ELIM | NO |
DROPPED | NO |
VISIBILITY | VISIBLE |
DOMIDX_MANAGEMENT | null |
SEGMENT_CREATED | YES |
NAME | VALUE |
---|---|
OWNER | CARTERAINVERSION_USER |
INDEX_NAME | ORDENINVERSION__IDXV1 |
TABLE_OWNER | CARTERAINVERSION_USER |
TABLE_NAME | ORDENINVERSION |
PARTITION_NAME | null |
PARTITION_POSITION | null |
SUBPARTITION_NAME | null |
SUBPARTITION_POSITION | null |
OBJECT_TYPE | INDEX |
BLEVEL | 0 |
LEAF_BLOCKS | 0 |
DISTINCT_KEYS | 0 |
AVG_LEAF_BLOCKS_PER_KEY | 0 |
AVG_DATA_BLOCKS_PER_KEY | 0 |
CLUSTERING_FACTOR | 0 |
NUM_ROWS | 0 |
AVG_CACHED_BLOCKS | null |
AVG_CACHE_HIT_RATIO | null |
SAMPLE_SIZE | 0 |
LAST_ANALYZED | 11/06/15 |
GLOBAL_STATS | NO |
USER_STATS | NO |
STATTYPE_LOCKED | null |
STALE_STATS | null |
PARTITION_NAME | LAST_ANALYZED | NUM_ROWS | LEAF_BLOCKS | DISTINCT_KEYS | SAMPLE_SIZE |
---|