Indexes

 < Day Day Up > 



set wrap off linesize 132 pages 80; column pos format 990; column col format a10; column ind format a25; column tab format a25; column typ format a20; column tbs format a25; select t.table_name "Tab"       ,decode(t.index_type,'NORMAL','BTree','BITMAP','Bitmap'             ,'FUNCTION-BASED NORMAL','Function-Based BTree'             ,t.index_type) "Typ"       ,t.index_name "Ind", c.column_name "Col",           c.column_position "Pos"       ,t.tablespace_name "Tbs" from user_indexes t, user_ind_columns c where t.table_name = c.table_name and t.index_name = c.index_name and t.index_type not in ('IOT – TOP','LOB') order by t.table_name, t.index_name, c.column_position;



 < Day Day Up > 



Oracle High Performance Tuning for 9i and 10g
Oracle High Performance Tuning for 9i and 10g
ISBN: 1555583059
EAN: 2147483647
Year: 2003
Pages: 164

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net