Re: Help !! need to find order of indexes on fields

Raj Rangarjan wrote:
>
> Hi,
> does anyone know how to find out what order the indexes on a
> table were created (ie if indexes i1,i2..iN were creted on fields
> f1,f2..fN of a table in order - I need to know the order i1,i2...iN)
>
> Any help would be appreciated. Please post your replies here or send
> them to raj_at_cs.clemson.edu
>
> Thanks
>
> --
> *******************************************
> -Rajasekaran Rangarajan
> -Administrative Progamming Services
> -Clemson University
> -Ph:(864) 656 0731/ Fax:(864) 656-0122

Hi Raj,

Take a look at the dictionary table all_ind_columns or user_ind_columns or dba_ind_columns (depending on what you want).

The column COLUMN_POSITION should tell you the order of columns in an index.

It is not clear from your posting if you need to find out timestamp ordering of indexes on a table or ordering of indexed columns in an index.

-- 
Subi Hanagal - Oracle DBA
Financial Planning Systems
Email: subi_at_ffsdev.ml.com, subi_at_gnn.com
Phone: 908-297-8240 (R), 908-627-6493 (W)