【在线相册】索引

SQL*Plus: Release 10.1.0.2.0 - Production on 星期四 6月 2 10:33:40 2011 Copyright (c) 1982, 2004, Oracle. All rights reserved. Connected to: Oracle Database 10g Enterprise Edition Release 10.1.0.2.0 - Production With the Partitioning, OLAP and Data Mining options SQL> conn album/album Connected. SQL> select table_name from user_tables; TABLE_NAME ------------------------------ PHOTOS USER_ALBUM ALBUM_TYPE USERS SQL> ed Wrote file afiedt.buf 1* SELECT * FROM user_indexes WHERE table_name=upper('users') SQL> / INDEX_NAME INDEX_TYPE ------------------------------ --------------------------- TABLE_OWNER TABLE_NAME TABLE_TYPE ------------------------------ ------------------------------ ----------- UNIQUENES COMPRESS PREFIX_LENGTH TABLESPACE_NAME INI_TRANS --------- -------- ------------- ------------------------------ ---------- MAX_TRANS INITIAL_EXTENT NEXT_EXTENT MIN_EXTENTS MAX_EXTENTS PCT_INCREASE ---------- -------------- ----------- ----------- ----------- ------------ PCT_THRESHOLD INCLUDE_COLUMN FREELISTS FREELIST_GROUPS PCT_FREE LOG ------------- -------------- ---------- --------------- ---------- --- BLEVEL LEAF_BLOCKS DISTINCT_KEYS AVG_LEAF_BLOCKS_PER_KEY ---------- ----------- ------------- ----------------------- AVG_DATA_BLOCKS_PER_KEY CLUSTERING_FACTOR STATUS NUM_ROWS SAMPLE_SIZE ----------------------- ----------------- -------- ---------- ----------- LAST_ANALYZED DEGREE -------------- ---------------------------------------- INSTANCES PAR T G S BUFFER_ USE DURATION ---------------------------------------- --- - - - ------- --- --------------- PCT_DIRECT_ACCESS ITYP_OWNER ITYP_NAME ----------------- ------------------------------ ------------------------------ PARAMETERS -------------------------------------------------------------------------------- GLO DOMIDX_STATU DOMIDX FUNCIDX_ JOI IOT DRO --- ------------ ------ -------- --- --- --- USER_PK NORMAL INDEX_NAME INDEX_TYPE ------------------------------ --------------------------- TABLE_OWNER TABLE_NAME TABLE_TYPE ------------------------------ ------------------------------ ----------- UNIQUENES COMPRESS PREFIX_LENGTH TABLESPACE_NAME INI_TRANS --------- -------- ------------- ------------------------------ ---------- MAX_TRANS INITIAL_EXTENT NEXT_EXTENT MIN_EXTENTS MAX_EXTENTS PCT_INCREASE ---------- -------------- ----------- ----------- ----------- ------------ PCT_THRESHOLD INCLUDE_COLUMN FREELISTS FREELIST_GROUPS PCT_FREE LOG ------------- -------------- ---------- --------------- ---------- --- BLEVEL LEAF_BLOCKS DISTINCT_KEYS AVG_LEAF_BLOCKS_PER_KEY ---------- ----------- ------------- ----------------------- AVG_DATA_BLOCKS_PER_KEY CLUSTERING_FACTOR STATUS NUM_ROWS SAMPLE_SIZE ----------------------- ----------------- -------- ---------- ----------- LAST_ANALYZED DEGREE -------------- ---------------------------------------- INSTANCES PAR T G S BUFFER_ USE DURATION ---------------------------------------- --- - - - ------- --- --------------- PCT_DIRECT_ACCESS ITYP_OWNER ITYP_NAME ----------------- ------------------------------ ------------------------------ PARAMETERS -------------------------------------------------------------------------------- GLO DOMIDX_STATU DOMIDX FUNCIDX_ JOI IOT DRO --- ------------ ------ -------- --- --- --- ALBUM USERS TABLE INDEX_NAME INDEX_TYPE ------------------------------ --------------------------- TABLE_OWNER TABLE_NAME TABLE_TYPE ------------------------------ ------------------------------ ----------- UNIQUENES COMPRESS PREFIX_LENGTH TABLESPACE_NAME INI_TRANS --------- -------- ------------- ------------------------------ ---------- MAX_TRANS INITIAL_EXTENT NEXT_EXTENT MIN_EXTENTS MAX_EXTENTS PCT_INCREASE ---------- -------------- ----------- ----------- ----------- ------------ PCT_THRESHOLD INCLUDE_COLUMN FREELISTS FREELIST_GROUPS PCT_FREE LOG ------------- -------------- ---------- --------------- ---------- --- BLEVEL LEAF_BLOCKS DISTINCT_KEYS AVG_LEAF_BLOCKS_PER_KEY ---------- ----------- ------------- ----------------------- AVG_DATA_BLOCKS_PER_KEY CLUSTERING_FACTOR STATUS NUM_ROWS SAMPLE_SIZE ----------------------- ----------------- -------- ---------- ----------- LAST_ANALYZED DEGREE -------------- ---------------------------------------- INSTANCES PAR T G S BUFFER_ USE DURATION ---------------------------------------- --- - - - ------- --- --------------- PCT_DIRECT_ACCESS ITYP_OWNER ITYP_NAME ----------------- ------------------------------ ------------------------------ PARAMETERS -------------------------------------------------------------------------------- GLO DOMIDX_STATU DOMIDX FUNCIDX_ JOI IOT DRO --- ------------ ------ -------- --- --- --- UNIQUE DISABLED USERS 2 INDEX_NAME INDEX_TYPE ------------------------------ --------------------------- TABLE_OWNER TABLE_NAME TABLE_TYPE ------------------------------ ------------------------------ ----------- UNIQUENES COMPRESS PREFIX_LENGTH TABLESPACE_NAME INI_TRANS --------- -------- ------------- ------------------------------ ---------- MAX_TRANS INITIAL_EXTENT NEXT_EXTENT MIN_EXTENTS MAX_EXTENTS PCT_INCREASE ---------- -------------- ----------- ----------- ----------- ------------ PCT_THRESHOLD INCLUDE_COLUMN FREELISTS FREELIST_GROUPS PCT_FREE LOG ------------- -------------- ---------- --------------- ---------- --- BLEVEL LEAF_BLOCKS DISTINCT_KEYS AVG_LEAF_BLOCKS_PER_KEY ---------- ----------- ------------- ----------------------- AVG_DATA_BLOCKS_PER_KEY CLUSTERING_FACTOR STATUS NUM_ROWS SAMPLE_SIZE ----------------------- ----------------- -------- ---------- ----------- LAST_ANALYZED DEGREE -------------- ---------------------------------------- INSTANCES PAR T G S BUFFER_ USE DURATION ---------------------------------------- --- - - - ------- --- --------------- PCT_DIRECT_ACCESS ITYP_OWNER ITYP_NAME ----------------- ------------------------------ ------------------------------ PARAMETERS -------------------------------------------------------------------------------- GLO DOMIDX_STATU DOMIDX FUNCIDX_ JOI IOT DRO --- ------------ ------ -------- --- --- --- 255 65536 1 2147483645 INDEX_NAME INDEX_TYPE ------------------------------ --------------------------- TABLE_OWNER TABLE_NAME TABLE_TYPE ------------------------------ ------------------------------ ----------- UNIQUENES COMPRESS PREFIX_LENGTH TABLESPACE_NAME INI_TRANS --------- -------- ------------- ------------------------------ ---------- MAX_TRANS INITIAL_EXTENT NEXT_EXTENT MIN_EXTENTS MAX_EXTENTS PCT_INCREASE ---------- -------------- ----------- ----------- ----------- ------------ PCT_THRESHOLD INCLUDE_COLUMN FREELISTS FREELIST_GROUPS PCT_FREE LOG ------------- -------------- ---------- --------------- ---------- --- BLEVEL LEAF_BLOCKS DISTINCT_KEYS AVG_LEAF_BLOCKS_PER_KEY ---------- ----------- ------------- ----------------------- AVG_DATA_BLOCKS_PER_KEY CLUSTERING_FACTOR STATUS NUM_ROWS SAMPLE_SIZE ----------------------- ----------------- -------- ---------- ----------- LAST_ANALYZED DEGREE -------------- ---------------------------------------- INSTANCES PAR T G S BUFFER_ USE DURATION ---------------------------------------- --- - - - ------- --- --------------- PCT_DIRECT_ACCESS ITYP_OWNER ITYP_NAME ----------------- ------------------------------ ------------------------------ PARAMETERS -------------------------------------------------------------------------------- GLO DOMIDX_STATU DOMIDX FUNCIDX_ JOI IOT DRO --- ------------ ------ -------- --- --- --- 10 YES INDEX_NAME INDEX_TYPE ------------------------------ --------------------------- TABLE_OWNER TABLE_NAME TABLE_TYPE ------------------------------ ------------------------------ ----------- UNIQUENES COMPRESS PREFIX_LENGTH TABLESPACE_NAME INI_TRANS --------- -------- ------------- ------------------------------ ---------- MAX_TRANS INITIAL_EXTENT NEXT_EXTENT MIN_EXTENTS MAX_EXTENTS PCT_INCREASE ---------- -------------- ----------- ----------- ----------- ------------ PCT_THRESHOLD INCLUDE_COLUMN FREELISTS FREELIST_GROUPS PCT_FREE LOG ------------- -------------- ---------- --------------- ---------- --- BLEVEL LEAF_BLOCKS DISTINCT_KEYS AVG_LEAF_BLOCKS_PER_KEY ---------- ----------- ------------- ----------------------- AVG_DATA_BLOCKS_PER_KEY CLUSTERING_FACTOR STATUS NUM_ROWS SAMPLE_SIZE ----------------------- ----------------- -------- ---------- ----------- LAST_ANALYZED DEGREE -------------- ---------------------------------------- INSTANCES PAR T G S BUFFER_ USE DURATION ---------------------------------------- --- - - - ------- --- --------------- PCT_DIRECT_ACCESS ITYP_OWNER ITYP_NAME ----------------- ------------------------------ ------------------------------ PARAMETERS -------------------------------------------------------------------------------- GLO DOMIDX_STATU DOMIDX FUNCIDX_ JOI IOT DRO --- ------------ ------ -------- --- --- --- 0 0 0 0 INDEX_NAME INDEX_TYPE ------------------------------ --------------------------- TABLE_OWNER TABLE_NAME TABLE_TYPE ------------------------------ ------------------------------ ----------- UNIQUENES COMPRESS PREFIX_LENGTH TABLESPACE_NAME INI_TRANS --------- -------- ------------- ------------------------------ ---------- MAX_TRANS INITIAL_EXTENT NEXT_EXTENT MIN_EXTENTS MAX_EXTENTS PCT_INCREASE ---------- -------------- ----------- ----------- ----------- ------------ PCT_THRESHOLD INCLUDE_COLUMN FREELISTS FREELIST_GROUPS PCT_FREE LOG ------------- -------------- ---------- --------------- ---------- --- BLEVEL LEAF_BLOCKS DISTINCT_KEYS AVG_LEAF_BLOCKS_PER_KEY ---------- ----------- ------------- ----------------------- AVG_DATA_BLOCKS_PER_KEY CLUSTERING_FACTOR STATUS NUM_ROWS SAMPLE_SIZE ----------------------- ----------------- -------- ---------- ----------- LAST_ANALYZED DEGREE -------------- ---------------------------------------- INSTANCES PAR T G S BUFFER_ USE DURATION ---------------------------------------- --- - - - ------- --- --------------- PCT_DIRECT_ACCESS ITYP_OWNER ITYP_NAME ----------------- ------------------------------ ------------------------------ PARAMETERS -------------------------------------------------------------------------------- GLO DOMIDX_STATU DOMIDX FUNCIDX_ JOI IOT DRO --- ------------ ------ -------- --- --- --- 0 0 VALID 0 0 INDEX_NAME INDEX_TYPE ------------------------------ --------------------------- TABLE_OWNER TABLE_NAME TABLE_TYPE ------------------------------ ------------------------------ ----------- UNIQUENES COMPRESS PREFIX_LENGTH TABLESPACE_NAME INI_TRANS --------- -------- ------------- ------------------------------ ---------- MAX_TRANS INITIAL_EXTENT NEXT_EXTENT MIN_EXTENTS MAX_EXTENTS PCT_INCREASE ---------- -------------- ----------- ----------- ----------- ------------ PCT_THRESHOLD INCLUDE_COLUMN FREELISTS FREELIST_GROUPS PCT_FREE LOG ------------- -------------- ---------- --------------- ---------- --- BLEVEL LEAF_BLOCKS DISTINCT_KEYS AVG_LEAF_BLOCKS_PER_KEY ---------- ----------- ------------- ----------------------- AVG_DATA_BLOCKS_PER_KEY CLUSTERING_FACTOR STATUS NUM_ROWS SAMPLE_SIZE ----------------------- ----------------- -------- ---------- ----------- LAST_ANALYZED DEGREE -------------- ---------------------------------------- INSTANCES PAR T G S BUFFER_ USE DURATION ---------------------------------------- --- - - - ------- --- --------------- PCT_DIRECT_ACCESS ITYP_OWNER ITYP_NAME ----------------- ------------------------------ ------------------------------ PARAMETERS -------------------------------------------------------------------------------- GLO DOMIDX_STATU DOMIDX FUNCIDX_ JOI IOT DRO --- ------------ ------ -------- --- --- --- 31-5月 -11 1 INDEX_NAME INDEX_TYPE ------------------------------ --------------------------- TABLE_OWNER TABLE_NAME TABLE_TYPE ------------------------------ ------------------------------ ----------- UNIQUENES COMPRESS PREFIX_LENGTH TABLESPACE_NAME INI_TRANS --------- -------- ------------- ------------------------------ ---------- MAX_TRANS INITIAL_EXTENT NEXT_EXTENT MIN_EXTENTS MAX_EXTENTS PCT_INCREASE ---------- -------------- ----------- ----------- ----------- ------------ PCT_THRESHOLD INCLUDE_COLUMN FREELISTS FREELIST_GROUPS PCT_FREE LOG ------------- -------------- ---------- --------------- ---------- --- BLEVEL LEAF_BLOCKS DISTINCT_KEYS AVG_LEAF_BLOCKS_PER_KEY ---------- ----------- ------------- ----------------------- AVG_DATA_BLOCKS_PER_KEY CLUSTERING_FACTOR STATUS NUM_ROWS SAMPLE_SIZE ----------------------- ----------------- -------- ---------- ----------- LAST_ANALYZED DEGREE -------------- ---------------------------------------- INSTANCES PAR T G S BUFFER_ USE DURATION ---------------------------------------- --- - - - ------- --- --------------- PCT_DIRECT_ACCESS ITYP_OWNER ITYP_NAME ----------------- ------------------------------ ------------------------------ PARAMETERS -------------------------------------------------------------------------------- GLO DOMIDX_STATU DOMIDX FUNCIDX_ JOI IOT DRO --- ------------ ------ -------- --- --- --- 1 NO N N N DEFAULT NO INDEX_NAME INDEX_TYPE ------------------------------ --------------------------- TABLE_OWNER TABLE_NAME TABLE_TYPE ------------------------------ ------------------------------ ----------- UNIQUENES COMPRESS PREFIX_LENGTH TABLESPACE_NAME INI_TRANS --------- -------- ------------- ------------------------------ ---------- MAX_TRANS INITIAL_EXTENT NEXT_EXTENT MIN_EXTENTS MAX_EXTENTS PCT_INCREASE ---------- -------------- ----------- ----------- ----------- ------------ PCT_THRESHOLD INCLUDE_COLUMN FREELISTS FREELIST_GROUPS PCT_FREE LOG ------------- -------------- ---------- --------------- ---------- --- BLEVEL LEAF_BLOCKS DISTINCT_KEYS AVG_LEAF_BLOCKS_PER_KEY ---------- ----------- ------------- ----------------------- AVG_DATA_BLOCKS_PER_KEY CLUSTERING_FACTOR STATUS NUM_ROWS SAMPLE_SIZE ----------------------- ----------------- -------- ---------- ----------- LAST_ANALYZED DEGREE -------------- ---------------------------------------- INSTANCES PAR T G S BUFFER_ USE DURATION ---------------------------------------- --- - - - ------- --- --------------- PCT_DIRECT_ACCESS ITYP_OWNER ITYP_NAME ----------------- ------------------------------ ------------------------------ PARAMETERS -------------------------------------------------------------------------------- GLO DOMIDX_STATU DOMIDX FUNCIDX_ JOI IOT DRO --- ------------ ------ -------- --- --- --- INDEX_NAME INDEX_TYPE ------------------------------ --------------------------- TABLE_OWNER TABLE_NAME TABLE_TYPE ------------------------------ ------------------------------ ----------- UNIQUENES COMPRESS PREFIX_LENGTH TABLESPACE_NAME INI_TRANS --------- -------- ------------- ------------------------------ ---------- MAX_TRANS INITIAL_EXTENT NEXT_EXTENT MIN_EXTENTS MAX_EXTENTS PCT_INCREASE ---------- -------------- ----------- ----------- ----------- ------------ PCT_THRESHOLD INCLUDE_COLUMN FREELISTS FREELIST_GROUPS PCT_FREE LOG ------------- -------------- ---------- --------------- ---------- --- BLEVEL LEAF_BLOCKS DISTINCT_KEYS AVG_LEAF_BLOCKS_PER_KEY ---------- ----------- ------------- ----------------------- AVG_DATA_BLOCKS_PER_KEY CLUSTERING_FACTOR STATUS NUM_ROWS SAMPLE_SIZE ----------------------- ----------------- -------- ---------- ----------- LAST_ANALYZED DEGREE -------------- ---------------------------------------- INSTANCES PAR T G S BUFFER_ USE DURATION ---------------------------------------- --- - - - ------- --- --------------- PCT_DIRECT_ACCESS ITYP_OWNER ITYP_NAME ----------------- ------------------------------ ------------------------------ PARAMETERS -------------------------------------------------------------------------------- GLO DOMIDX_STATU DOMIDX FUNCIDX_ JOI IOT DRO --- ------------ ------ -------- --- --- --- INDEX_NAME INDEX_TYPE ------------------------------ --------------------------- TABLE_OWNER TABLE_NAME TABLE_TYPE ------------------------------ ------------------------------ ----------- UNIQUENES COMPRESS PREFIX_LENGTH TABLESPACE_NAME INI_TRANS --------- -------- ------------- ------------------------------ ---------- MAX_TRANS INITIAL_EXTENT NEXT_EXTENT MIN_EXTENTS MAX_EXTENTS PCT_INCREASE ---------- -------------- ----------- ----------- ----------- ------------ PCT_THRESHOLD INCLUDE_COLUMN FREELISTS FREELIST_GROUPS PCT_FREE LOG ------------- -------------- ---------- --------------- ---------- --- BLEVEL LEAF_BLOCKS DISTINCT_KEYS AVG_LEAF_BLOCKS_PER_KEY ---------- ----------- ------------- ----------------------- AVG_DATA_BLOCKS_PER_KEY CLUSTERING_FACTOR STATUS NUM_ROWS SAMPLE_SIZE ----------------------- ----------------- -------- ---------- ----------- LAST_ANALYZED DEGREE -------------- ---------------------------------------- INSTANCES PAR T G S BUFFER_ USE DURATION ---------------------------------------- --- - - - ------- --- --------------- PCT_DIRECT_ACCESS ITYP_OWNER ITYP_NAME ----------------- ------------------------------ ------------------------------ PARAMETERS -------------------------------------------------------------------------------- GLO DOMIDX_STATU DOMIDX FUNCIDX_ JOI IOT DRO --- ------------ ------ -------- --- --- --- YES NO NO NO INDEX_NAME INDEX_TYPE ------------------------------ --------------------------- TABLE_OWNER TABLE_NAME TABLE_TYPE ------------------------------ ------------------------------ ----------- UNIQUENES COMPRESS PREFIX_LENGTH TABLESPACE_NAME INI_TRANS --------- -------- ------------- ------------------------------ ---------- MAX_TRANS INITIAL_EXTENT NEXT_EXTENT MIN_EXTENTS MAX_EXTENTS PCT_INCREASE ---------- -------------- ----------- ----------- ----------- ------------ PCT_THRESHOLD INCLUDE_COLUMN FREELISTS FREELIST_GROUPS PCT_FREE LOG ------------- -------------- ---------- --------------- ---------- --- BLEVEL LEAF_BLOCKS DISTINCT_KEYS AVG_LEAF_BLOCKS_PER_KEY ---------- ----------- ------------- ----------------------- AVG_DATA_BLOCKS_PER_KEY CLUSTERING_FACTOR STATUS NUM_ROWS SAMPLE_SIZE ----------------------- ----------------- -------- ---------- ----------- LAST_ANALYZED DEGREE -------------- ---------------------------------------- INSTANCES PAR T G S BUFFER_ USE DURATION ---------------------------------------- --- - - - ------- --- --------------- PCT_DIRECT_ACCESS ITYP_OWNER ITYP_NAME ----------------- ------------------------------ ------------------------------ PARAMETERS -------------------------------------------------------------------------------- GLO DOMIDX_STATU DOMIDX FUNCIDX_ JOI IOT DRO --- ------------ ------ -------- --- --- --- SQL> set linesize 120 SQL> set pagesize 120 Wrote file afiedt.buf 1* SELECT index_name FROM user_indexes WHERE table_name=upper('users') SQL> / INDEX_NAME ------------------------------ USER_PK SQL> ed Wrote file afiedt.buf 1* SELECT index_name FROM user_indexes WHERE table_name=upper('album_type') SQL> / INDEX_NAME ------------------------------ ALBUM_TYPE_PK SQL> ed Wrote file afiedt.buf 1* SELECT index_name FROM user_indexes WHERE table_name=upper('user_album') SQL> / INDEX_NAME ------------------------------ USER_ALBUM_PK SQL> ed Wrote file afiedt.buf 1* SELECT index_name FROM user_indexes WHERE table_name=upper('photos') SQL> / INDEX_NAME ------------------------------ SYS_IL0000050928C00004$$ PHOTO_PK

blob这个东西还是挺复杂的，多出来的一个索引据说和它有关