Would suggest testing first with choose. If you were application
was written for RULE it might not run good for CHOOSE. It could run
better, same or worse.
Jeffrey Beckstrom
Database Administrator
Greater Cleveland Regional
Transit Authority
1240 W. 6th Street
Cleveland, Ohio 44113
(216)
781-4204
>>>
[EMAIL PROTECTED]
10/18/01 9:20:24 AM >>>
Hello
We upgraded our Oracle
version from 7.3 to Oracle 8.1.7 for a couple of
months ago. In Ora 7
environment we used optimizer mode RULE, but now we
would like to change to
CHOOSE, and hopefully gain some performance.
As far as I understand
everything, we must collect statistics for the
different schemas in the
database to have any advantage of the cost based
optimizer mode. Our plan
is to do this once a week (is this good enought or
too often?). According
to Oracle manual, I should use the dbms_stats package
to get statistics. So
a run the following procedure to get
statistics:
DBMS_STATS.GATHER_SCHEMA_STATS
(ownname =>
'<schema>',
estimate_percent => 10,
block_sample =>
TRUE,
method_opt => 'FOR ALL COLUMNS
SIZE
1',
degree =>
NULL,
granularity => 'DEFAULT',
cascade =>
TRUE);
I plan to schedule this and run it once a week. Is this all I
have to do? It
seem too easy. There must some catch somewhere or
??
I'm thankfull for any help
/Jonas
--
Please see the
official ORACLE-L FAQ:
http://www.orafaq.com--
Author: Jonas
A Wetterberg
INET: [EMAIL PROTECTED]
Fat City
Network Services -- (858) 538-5051 FAX: (858)
538-5051
San Diego, California --
Public Internet access / Mailing
Lists
--------------------------------------------------------------------
To
REMOVE yourself from this mailing list, send an E-Mail message
to:
[EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message
BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing
list you want to be removed from). You may
also send the HELP command
for other information (like subscribing).
