Re: generate index ddl

From: robert <gnuoytr_at_rcn.com>
Date: 5 Sep 2003 11:25:23 -0700
Message-ID: <da3c2186.0309051025.3baea7e1_at_posting.google.com>


Mark.Powell_at_eds.com (Mark D Powell) wrote in message news:<2687bb95.0309041713.1adf70e1_at_posting.google.com>...
> gnuoytr_at_rcn.com (robert) wrote in message news:<da3c2186.0309041303.7fa5b96e@posting.google.com>...
> > i've seen the various threads, and looked at the
> > *_index views and the tables in sys. what i don't see,
> > and i use Advanced Query Tool (which shows it), is the
> > ordering of columns in an index.
> >
> > is there an "obvious" location for this??
> >
> > thanks,
> > robert
>
> Try looking again: DBA_IND_COLUMNS.COLUMN_POSITION
>
> HTH -- Mark D Powell --

i had. when viewed in AQT, all of them are 0 .

hmm.

thanks,
robert Received on Fri Sep 05 2003 - 20:25:23 CEST

Original text of this message