Re: new to indexes

From: Michel Cadot <micadot_at_netcourrier.com>
Date: Mon, 13 Mar 2000 14:28:12 +0100
Message-ID: <8aiqdt$jkc$1@news6.isdnet.net>

kev <kevin.porter_at_fast.no> a écrit dans le message : 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?

The following query gives you all indexes on each of your tables:

select table_name, index_name from user_indexes order by 1, 2
/

> Also, if I've defined a primary key for each table, is an index created
> automatically for them?

When you define a primary key, if there is no already created index that can implement this primary key, Oracle automatically creates one.

>
> thanks,
>
> - Kev
>

--
Have a nice day
Michel Received on Mon Mar 13 2000 - 07:28:12 CST