ace1234567

 Profile Answers by ace1234567 

• Mar 4th, 2015

 

update the statistics of all the tables used in the query. Check the explain plan. Check whether query is using the existing indexes. If required add/modify new indexes. Check for the sequence of conditions in where clause. Try to use "exist" rather than "in" for subqueries returning big number of rows.

Sudhir Kumar

• Jan 20th, 2016

 

Try to make use of mqts or temporary tables if possible ..try to transfer the conditions from non key columns to key columns