Re: Index
From: Reinhard Kuhn <kuhn_at_cas-ps.com>
Date: 1996/02/23
Message-ID: <4gktkl$4d1_at_fred.cas-ps.com>#1/1
Date: 1996/02/23
Message-ID: <4gktkl$4d1_at_fred.cas-ps.com>#1/1
In article <3128D45F.1E4_at_nt.com>, carlos.ng.0141758_at_nt.com says...
>How do I view my indexes definition on a table. What system catalog table
should
- snip ----------------------------------------- select a.index_name, a.column_name, a.column_position, b.uniqueness, b.tablespace_name from all_ind_columns a, user_indexes b where a.table_name = upper( <TABLE> ) and a.index_name = b.index_name order by a.index_name, a.column_position
- snip ----------------------------------------- -- _/_/_/ _/_/_/ _/ _/ // Reinhard Kuhn / It can be _/ _/ _/ _/ _/ // (kuhn_at_cas-ps.com) / done quickly, _/_/_/ _/_/_/ _/_/ // CAS GmbH / cheaply or well _/ _/ _/ _/ _/ // Lemberger Strasse 14 / - pick any two! _/ _/ _/_/_/ _/ _/ // 66955 Pirmasens, Germany /