DB2 V10.5 Tuning of SQL and PL/SQL
Page 1 of 1
DB2 V10.5 Tuning of SQL and PL/SQL
How many ways can we tuning SQL and PL/SQL in DB2?
srini- Posts : 68
Points : 150
Reputation : 0
Join date : 2013-12-16
Re: DB2 V10.5 Tuning of SQL and PL/SQL
The following are the ways we can tune:
•Take out any / all Scalar functions coded on columns that are part of the Where clause.
•Take out any / all mathematics on columns that are part of the Where clause.
•Watch out for Distinct, it often causes sorts in order to bring back unique values.
•Try rewriting 'In' non correlated subqueries as as 'Exists' correlated subqueries.
•Minimize the number of SQL statements sent to DB2 from your program code.
•Try rewriting the query a different way, or rewriting any of the SQL predicates differently.
http://www.amazon.com/DB2-Tuning-Tips-Developers-Press/dp/0133038467/ref=sr_1_1?s=books&ie=UTF8&qid=1389336875&sr=1-1&keywords=DB2+sql+tuning
•Take out any / all Scalar functions coded on columns that are part of the Where clause.
•Take out any / all mathematics on columns that are part of the Where clause.
•Watch out for Distinct, it often causes sorts in order to bring back unique values.
•Try rewriting 'In' non correlated subqueries as as 'Exists' correlated subqueries.
•Minimize the number of SQL statements sent to DB2 from your program code.
•Try rewriting the query a different way, or rewriting any of the SQL predicates differently.
http://www.amazon.com/DB2-Tuning-Tips-Developers-Press/dp/0133038467/ref=sr_1_1?s=books&ie=UTF8&qid=1389336875&sr=1-1&keywords=DB2+sql+tuning
Last edited by srini on Fri Jan 10, 2014 12:25 pm; edited 1 time in total (Reason for editing : Added link)
srini- Posts : 68
Points : 150
Reputation : 0
Join date : 2013-12-16
Page 1 of 1
Permissions in this forum:
You cannot reply to topics in this forum
|
|