Praveen reddy.P

• Jan 31st, 2007

 

HiTo improve the performance of a Query, The following are the steps to be followed.1) First Check the Elapsced time of the Query2) Then see the optimization mode 3) Run the query in different optimization mode 4) If any index are used see that it is enabled.5) And check whether it is undergoing Full table 6) If not Create the index for the oppx columns to spreed up the Query(Should be in the case of Select only)7) Check the where clause if any unsuspicues activity is happening.8) If u r using sub-queries or rather corelated check the fllow which to be best possible out come.