Re: oracle 8.1.6 optimizer settings!

From: Dhananjay Sen <dhananjay_sen_at_hotmail.com>
Date: 12 Jun 2001 08:43:53 -0700
Message-ID: <2e5b0db8.0106120743.3997d4bf@posting.google.com>

Murat --

init.ora parameter for optimizer settings is OPTIMIZER_MODE .

Values are :

 CHOOSE       -- Cost based optimization 
 RULE         -- Rule Based optimization
 FIRST_ROWS   -- Genrally forces index
 ALL_ROWS     -- Generally forces index suppression

The default OPTIMIZER_MODE in Oracle8i(8.1.6 , 8.1.7) is 'CHOOSE' . However all tables need to be analyzed using 'ANALYZE TABLE....' to use cost based optimization .

Regards

Dhananjay

"Murat YILDIZ" <myildiz_at_bellona.com.tr> wrote in message news:<9g4a9q$6r045$1_at_ID-82167.news.dfncis.de>...
> Hi,
> what init.ora parameters are available for optimizer settings(like joins and
> so on)?Does the optimizer use the CBO in default?(vers. 8.1.6)thanks..
>
> Murat
Received on Tue Jun 12 2001 - 10:43:53 CDT