http://www.sqle.ru/index.php?action=history&feed=atom&title=Oracle_PL%2FSQL_Tutorial%2FSystem_Tables_Data_Dictionary%2Fall_indexes 2026-05-24T04:29:52Z История изменений этой страницы в вики MediaWiki 1.30.0 http://www.sqle.ru/index.php?title=Oracle_PL/SQL_Tutorial/System_Tables_Data_Dictionary/all_indexes&diff=3871&oldid=prev 2010-05-26T13:45:46Z

<p></p> <table class="diff diff-contentalign-left" data-mw="interface"> <tr style="vertical-align: top;" lang="ru"> <td colspan="1" style="background-color: white; color:black; text-align: center;">← Предыдущая</td> <td colspan="1" style="background-color: white; color:black; text-align: center;">Версия 13:45, 26 мая 2010</td> </tr><tr><td colspan="2" style="text-align: center;" lang="ru"><div class="mw-diff-empty">(нет различий)</div> </td></tr></table>

http://www.sqle.ru/index.php?title=Oracle_PL/SQL_Tutorial/System_Tables_Data_Dictionary/all_indexes&diff=3872&oldid=prev 2010-05-26T10:08:02Z

<p>1 версия</p> <p><b>Новая страница</b></p><div>== Get information on all the indexes you have access to using all_indexes.==<br /> <br /> <br /> <br /> <br /> &lt;!-- start source code --&gt;<br /> <br /> &lt;source lang=&quot;sql&quot;&gt;<br /> SQL&gt;<br /> SQL&gt; desc all_indexes;<br /> Name Null? Type<br /> OWNER NOT NULL VARCHAR2(30)<br /> INDEX_NAME NOT NULL VARCHAR2(30)<br /> INDEX_TYPE VARCHAR2(27)<br /> TABLE_OWNER NOT NULL VARCHAR2(30)<br /> TABLE_NAME NOT NULL VARCHAR2(30)<br /> TABLE_TYPE CHAR(5)<br /> UNIQUENESS VARCHAR2(9)<br /> COMPRESSION VARCHAR2(8)<br /> PREFIX_LENGTH NUMBER<br /> TABLESPACE_NAME VARCHAR2(30)<br /> INI_TRANS NUMBER<br /> MAX_TRANS NUMBER<br /> INITIAL_EXTENT NUMBER<br /> NEXT_EXTENT NUMBER<br /> MIN_EXTENTS NUMBER<br /> MAX_EXTENTS NUMBER<br /> PCT_INCREASE NUMBER<br /> PCT_THRESHOLD NUMBER<br /> INCLUDE_COLUMN NUMBER<br /> FREELISTS NUMBER<br /> FREELIST_GROUPS NUMBER<br /> PCT_FREE NUMBER<br /> LOGGING VARCHAR2(3)<br /> BLEVEL NUMBER<br /> LEAF_BLOCKS NUMBER<br /> DISTINCT_KEYS NUMBER<br /> AVG_LEAF_BLOCKS_PER_KEY NUMBER<br /> AVG_DATA_BLOCKS_PER_KEY NUMBER<br /> CLUSTERING_FACTOR NUMBER<br /> STATUS VARCHAR2(8)<br /> NUM_ROWS NUMBER<br /> SAMPLE_SIZE NUMBER<br /> LAST_ANALYZED DATE<br /> DEGREE VARCHAR2(40)<br /> INSTANCES VARCHAR2(40)<br /> PARTITIONED VARCHAR2(3)<br /> TEMPORARY VARCHAR2(1)<br /> GENERATED VARCHAR2(1)<br /> SECONDARY VARCHAR2(1)<br /> BUFFER_POOL VARCHAR2(7)<br /> USER_STATS VARCHAR2(3)<br /> DURATION VARCHAR2(15)<br /> PCT_DIRECT_ACCESS NUMBER<br /> ITYP_OWNER VARCHAR2(30)<br /> ITYP_NAME VARCHAR2(30)<br /> PARAMETERS VARCHAR2(1000)<br /> GLOBAL_STATS VARCHAR2(3)<br /> DOMIDX_STATUS VARCHAR2(12)<br /> DOMIDX_OPSTATUS VARCHAR2(6)<br /> FUNCIDX_STATUS VARCHAR2(8)<br /> JOIN_INDEX VARCHAR2(3)<br /> IOT_REDUNDANT_PKEY_ELIM VARCHAR2(3)<br /> DROPPED VARCHAR2(3)<br /> SQL&gt;<br /> SQL&gt; --select * from all_indexes;<br /> SQL&gt;&lt;/source&gt;</div>

Admin