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

raj_at_cs.clemson.edu (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
>

Look at USER_IND_COLUMNS (or DBA_IND_COLUMNS or ALL_IND_COUMNS) at column COLUMN_POSITION. This will give you the order of the index.

DL Kray Received on Fri Mar 22 1996 - 00:00:00 CET