| Performance tuning [message #393498] |
Mon, 23 March 2009 02:10  |
sivakumar.rj
Messages: 17
Registered: November 2008
Location: Chennai
|
Junior Member |
|
|
Hello all,
I need to tune a query. This query is taking 2 much long time. If I use RULE hint, the query executes faster. But if the rule is removed, the query is hanging. So please help on this how to rewrite the query.
The query is actually using 5 tables.
Out of 5 tables, one table uses outer join, the other with equal to condition and the others with not equal to condtion, and the other table is using like condition. Help me in solving the query.....
|
|
|
|
|
|
| Re: Performance tuning [message #393818 is a reply to message #393498] |
Tue, 24 March 2009 08:40  |
JRowbottom
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...
|
Senior Member |
|
|
Based on the information provided, the only help I can provide is to recommend that you gather statistics on your tables using DBMS_STATS.
Read the sticky post at the top of the forum, and provide as much of the information as you ca,, and someone will probably try to help.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
