I have four tables and 5 joins condition. Yesterday it tooks 1 minutes to execute and today getting more then 1 hour so what is your first action to tune ?
[B]Question asked by visitor Raj[/B]
Printable View
I have four tables and 5 joins condition. Yesterday it tooks 1 minutes to execute and today getting more then 1 hour so what is your first action to tune ?
[B]Question asked by visitor Raj[/B]
try to get the query execution plan,
1. Then see is there any full table scan... then either create index on the column(s) in the where conditions of there is no index on them. If Index is already there then you can introduce hints to use those indexes( you should be very careful while using index because once it sees the hint oracle blindly follow the hint without using its own logic ).
For sql query tuning post your query here...
Try creating indexes on the table.
Using hint is also another option.
But oracle never folows hints blindly,because hints are always optional.
It uses hints only if the cost of the hist is less.