Re: new to indexes

From: Kevin A Lewis <Kevin_A_Lewis_at_Hotmail.com>
Date: Mon, 13 Mar 2000 13:29:26 GMT
Message-ID: <W26z4.16$lw5.1736@newreader.ukcore.bt.net>

Try selecting against USER_INDEXES and USER_IND_COLUMNS for your own schemas indexes. For another schema you have access replace USER_ with ALL_ or if appropriate change USER_ for DBA_ which if accessible will show for all schemas.

Regards

--
Kevin A Lewis (BOCM PAULS LTD) - Animal Feed Manufacturer - Ipswich United Kingdom)

                        <Kevin_A_Lewis_at_Hotmail.com>

The views expressed herein by the author of this document are not necessarily those of BOCM PAULS Ltd. kev <kevin.porter_at_fast.no> wrote in message news:38CCD4B9.926326D1_at_fast.no...
> Hi,
>
> I'm looking at how to index my (quite complicated) data. I'd like to
> know if there is a V$ view which will show me what indexes are already
> in existence. I couldn't find one - if there isn't, how else do I find
> this information?
> Also, if I've defined a primary key for each table, is an index created
> automatically for them?
>
> thanks,
>
> - Kev
>
Received on Mon Mar 13 2000 - 07:29:26 CST