Home » SQL & PL/SQL » SQL & PL/SQL » Index regarding
Index regarding [message #206798] Fri, 01 December 2006 09:50 Go to next message
sv.venkat
Messages: 12
Registered: July 2006
Location: HYDERABAD
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.
bye
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: 10672
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 Dec 04 02:46:12 CST 2016

Total time taken to generate the page: 0.04262 seconds