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

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.

next

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

do plz suggest me about this...

Thanks
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 ?
Next Topic: STATSPACK
Goto Forum:
  


Current Time: Sat Dec 03 12:14:16 CST 2016

Total time taken to generate the page: 0.11890 seconds