Home » RDBMS Server » Performance Tuning » SQL Statement Tuning
SQL Statement Tuning [message #217905] Tue, 06 February 2007 01:10 Go to next message
Messages: 11
Registered: December 2006
Location: india
Junior Member
i am using oracle

i have a sql statement joining 12 tables, which earlier use to execuate between 12 to 14 sec, now it's taking 3.2 to 4.3 sec.

from my observation I have 2 set of plans.

1. where cost is about 43 it exec in 3.2 to 4.3 sec avg.
2. where cost is about 20 it exec in 12 to 14 sec avg.

can any one explain me on this.


is their any method to bring down the exec of statement
from 3.2 sec..

do plz suggest me about this...

Re: SQL Statement Tuning [message #217998 is a reply to message #217905] Tue, 06 February 2007 05:52 Go to previous message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
>> bring down the exec of statement from 3.2 sec..
to what?
1 nanosecond?
>>can any one explain me on this.
I would look into 10053 trace output to see why CBO chose the other plan. Where the queries run in identical load/data situations?
Previous Topic: How to push Hash Anti join without HINT or code modification ?
Goto Forum:

Current Time: Sun Oct 23 13:49:24 CDT 2016

Total time taken to generate the page: 0.08764 seconds