sekhu_da

 Profile Answers by sekhu_da Questions by sekhu_da

• Nov 14th, 2006

 

question not clear !

vanni

• Jan 2nd, 2007

 

The performance of an application can be monitored and enhanced in the application, as well as at the database level.
?In application side the SQL?s can be tuned to make them more efficient, and avoid redundancy.
?It is better to structure the SQLs so that they perform only the necessary operations.
?On the database side, the major enhancements can be done to the definitions of tables, indexes & the distribution of tablespace and indexspace.
?The application run statistics are obtained from EXPLAIN or DB2PM (DB2 Performance Monitor) report.

yuvaevergreen

 Profile Answers by yuvaevergreen 

• Mar 26th, 2010

 

Database design tuning can be 65%
SQL design tuning can be 25%

sagar reddy

• Apr 1st, 2015

 

Verifying weather a query is performing well or not

aravindhan

• Oct 8th, 2015

 

Code
SELECT * FROM TABLE1 WHERE CO_ID=CP AND EMP_ID>1000 -> This query running 10 minutes.


SELECT * FROM TABLE1 WHERE CO_ID=CP AND EMP_ID>1000 AND EMP_ID<2000 

This query running 5 minutes.
This is called performance tuning.