Re: cost based optimization

From: Jill <jc_va_at_hotmail.com>
Date: Sat, 28 Aug 1999 06:44:58 -0700
Message-ID: <7q8ekf$jvl$1@bgtnsc03.worldnet.att.net>

Yes, it does not require a hint on a specific query. If you want it to use a specific type of access or index, you can use a hint, but without one, the CBO will decide for itself.

How often depends on how often the data distribution and row counts change. Your mileage may vary.

Anurag Minocha wrote in message <37C7854E.BCD1E518_at_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 - 08:44:58 CDT