Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> cost based optimization

cost based optimization

From: Anurag Minocha <anurag_at_synergy-infotech.com>
Date: Sat, 28 Aug 1999 12:14:30 +0530
Message-ID: <37C7854E.BCD1E518@synergy-infotech.com>


Hi,
I am a little confused about Cost Based Optimization.Please help me out.

1.Does the cost based optimization work on those sql queries which dont have hints specified in them.?

2. How frequently should the tables be analysed.

Any help will be greatly appreciated.

Thanks
anurag

also reply to
anurag_at_synergy-infotech.com Received on Sat Aug 28 1999 - 01:44:30 CDT

Original text of this message

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