How to optimize SQL Statements?

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

ace1234567

 Profile Answers by ace1234567 Questions 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 cond...

Answer Question  Select Best Answer