Re: which columns are indexed

From: <argosy22_at_my-deja.com>
Date: 2000/07/17
Message-ID: <8kvgvo$2st$1@nnrp1.deja.com>#1/1

save this as a script, and run it from sqlplus.

break on index_name;
accept ls_table_name prompt "Enter the table to list indexes for: " ; select substr(index_name, 1, 30) index_name,

         substr(column_name, 1, 20)  column_name,
         column_position

from all_ind_columns
where table_name = ltrim(rtrim(upper('&ls_table_name'))) order by TABLE_OWNER, 1, 3, 2;

In article <397339CB.978FF636_at_its.brooklyn.cuny.edu>,   A D Hager <adhager_at_its.brooklyn.cuny.edu> wrote:
> Is there any way to determine which columns in a table have been
> indexed?
> Is there any way to determine what ann index indexes?
>
> Thanks,
>
> Aaron
>
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Mon Jul 17 2000 - 00:00:00 CDT