Re: which columns are indexed
From: <argosy22_at_my-deja.com>
Date: 2000/07/17
Message-ID: <8kvgvo$2st$1_at_nnrp1.deja.com>#1/1
from all_ind_columns
where table_name = ltrim(rtrim(upper('&ls_table_name'))) order by TABLE_OWNER, 1, 3, 2;
Date: 2000/07/17
Message-ID: <8kvgvo$2st$1_at_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 CEST