Home » SQL & PL/SQL » SQL & PL/SQL » Index regarding
Index regarding [message #206798] Fri, 01 December 2006 09:50 Go to next message
Messages: 12
Registered: July 2006
Junior Member
Dear Friends,
How to instruct our query to use only one of the indexes but that base object has got two indexes?
Thank U in advance Friends.
Venkateswara Rao
Re: Index regarding [message #206805 is a reply to message #206798] Fri, 01 December 2006 10:35 Go to previous message
Mahesh Rajendran
Messages: 10673
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
May i ask why?
In most cases, it better to leave CBO to do its job.
Previous Topic: Create Oracle 9i Documentation
Next Topic: Outer Joins
Goto Forum:

Current Time: Sun Jul 23 00:22:41 CDT 2017

Total time taken to generate the page: 1.18674 seconds