Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Does oracle guarantees index access for a query execution
I have indexes created on table mytb, explain plan of sql query which
uses mytb shows all the indexes used which I have created.
My question is does the indexes are used every time I execute the
query.
Also, if a index is created by oracle for UNIQUE and PRIMARY KEY
Columns.. does it uses such indexes everytime
a query executed.
Received on Wed Mar 28 2007 - 07:03:48 CDT
![]() |
![]() |