Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: new to indexes

Re: new to indexes

From: Grant Langley <grant.langley_at_jcu.edu.au>
Date: Thu, 06 Apr 2000 10:33:30 +1000
Message-ID: <38EBDB5A.583E3467@jcu.edu.au>


Download the free version of toad from http://www.toadsoft.com/ - this gives a gui wrapper for these types of queries (to see query use the tuning -> spool sql option).

kev wrote:
>
> 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

--
Grant Langley Received on Wed Apr 05 2000 - 19:33:30 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US