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 -> new to indexes

new to indexes

From: kev <kevin.porter_at_fast.no>
Date: Mon, 13 Mar 2000 11:44:57 +0000
Message-ID: <38CCD4B9.926326D1@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,

Received on Mon Mar 13 2000 - 05:44:57 CST

Original text of this message

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