Title: MTSCost based Optimzer
Hello folks!
I am working in SUN solaris 5.6 with Oracle 8i. I want to implement MTS on the Oracle server. Next we are running with Rule based optimizer and we want to change to costbased optimizer.
I want to know what are the advantages we get
recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: MTSCost based Optimzer
Date: Tue, 24 Apr 2001 02:25:25 -0800
Hello folks!
I am working in SUN solaris 5.6 with Oracle 8i. I want to implement MTS
on the Oracle server. Next we are running with Rule based optimizer and
we want to change
in queries to force the optimizer to run rule.
From: Venkat_Kalepalli [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: MTSCost based Optimzer
Date: Tue, 24 Apr 2001 02:25:25 -0800
Hello folks!
I am working in SUN solaris 5.6
in queries to force the optimizer to run rule.
From: Venkat_Kalepalli [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: MTSCost based Optimzer
Date: Tue, 24 Apr 2001 02:25:25 -0800
Hello folks!
I am working in SUN solaris
-L [EMAIL PROTECTED]
Subject: RE: MTSCost based Optimzer
Date: Tue, 24 Apr 2001 08:21:57 -0800
Rachel
I recently heard about something called a Stored Outline that supposedly
can
be used to lock the execution path that a query runs with. One of the uses
of this was apparently to aid people moving
PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: RE: MTSCost based Optimzer
Date: Tue, 24 Apr 2001 07:51:18 -0800
I wouldn't... analyze all or nothing...
[EMAIL PROTECTED] 04/24/01 09:46AM
How would you decide that out of total big and small
the large table and join
it to an unanalyzed small table, you are going to get rule based
From: Tim Sawmiller [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: RE: MTSCost based Optimzer
Date: Tue, 24 Apr 2001 07:51:18 -0800
I
On Tuesday 24 April 2001 06:15, Rachel Carmichael wrote:
HOWEVER (and this is a biggie) this will not automatically make all your
queries run faster.
LOL!
Most of us here know this, but for the benefit of you that don't, here goes.
If your system is running fine on rule-based