Re: Optimization

From: <marcpark_at_my-deja.com>
Date: 2000/04/26
Message-ID: <8e7nj3$s3$1@nnrp1.deja.com>#1/1

If you want an individual sql command to use the rule hint add /*+ rule */ to your command. (select /*+ rule */

                              ...
                              from ..)

You need to be vary carefull with the rule hint. Bit mapped indexes are not used by the rule hint. Addionally, the RBO has not been imporved by Oracle for serveral versions. The CBO is constantly being updated.

Marc G. Parkinson

In article <054b3ae4.c12b3b6c_at_usw-ex0104-031.remarq.com>,   dt <db2userNOdbSPAM_at_aol.com.invalid> wrote:
> Hi all, this might be a silly question.
> How does one tell what type of optimization
> is being used on the server, rule-based or
> cost-based?
>
> Thanks.
>
> David T.
>
> * Sent from RemarQ http://www.remarq.com The Internet's Discussion
 Network *
> The fastest and easiest way to search and participate in Usenet -
 Free!
>
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Wed Apr 26 2000 - 00:00:00 CDT