Re: Oracle 9i - switching to rule based optimizer optimizer

From: Sybrand Bakker <gooiditweg_at_sybrandb.verwijderdit.demon.nl>
Date: Fri, 21 Jan 2005 20:34:03 +0100
Message-ID: <p7m2v0dp06qckj5i9duioch9ahr5mobhh6@4ax.com>

On 21 Jan 2005 11:20:43 -0800, pheimill_at_netscape.net wrote:

>In 8i, if the init.ora initialization parameter optimizer_goal=choose
>was set, then removing statistics would cause oracle to use the rule
>based optimizer. Does anyone know if 9i works the same way? We would
>like to try out the rule based optimizer during some testing, but
>don't want to effect others on the same instance.

definitely a doc question.

and RBO is a dead ally.

--
Sybrand Bakker, Senior Oracle DBA

Received on Fri Jan 21 2005 - 13:34:03 CST

This message: [ Message body ]
Next message: DA Morgan: "Re: Netapps vs EMC -- db file scattered read"
Previous message: TR: "Any website, where I can get docuementation about RDBMS Concepts and Datawarehousing"
In reply to: pheimill_at_netscape.net: "Oracle 9i - switching to rule based optimizer optimizer"
Next in thread: Jesse: "Re: Oracle 9i - switching to rule based optimizer optimizer"
Reply: Jesse: "Re: Oracle 9i - switching to rule based optimizer optimizer"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message

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