How can we remove/optmize source bottlenecks using "query hints"

Questions by me_nagu

Showing Answers 1 - 3 of 3 Answers

siri

  • Feb 14th, 2007
 

Create indexes for source table colums

  Was this answer useful?  Yes

toffycoffy

  • Feb 27th, 2007
 

first, u must have proper indexes and the table must be analyzed to gather stats to use the cbo.  u can get free doc from oracle technet.

use the hints after and it is powerful so be careful with the hints.

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions