| SQL Statement Tuning [message #217905] |
Tue, 06 February 2007 01:10  |
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  |
 |
Mahesh Rajendran
Messages: 10707
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?
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
