SriniForum
Hello Friend,
Welcome to Fully Optimized Discussion Forum.
Leading Forum in India

Join the forum, it's quick and easy

SriniForum
Hello Friend,
Welcome to Fully Optimized Discussion Forum.
Leading Forum in India
SriniForum
Would you like to react to this message? Create an account in a few clicks or log in to continue.

DB2 V10.5 Tuning of SQL and PL/SQL

Go down

DB2 V10.5 Tuning of SQL and PL/SQL Empty DB2 V10.5 Tuning of SQL and PL/SQL

Post by srini Sat Dec 21, 2013 2:06 pm

How many ways can we tuning SQL and PL/SQL in DB2?

srini

Posts : 68
Points : 150
Reputation : 0
Join date : 2013-12-16

Back to top Go down

DB2 V10.5 Tuning of SQL and PL/SQL Empty Re: DB2 V10.5 Tuning of SQL and PL/SQL

Post by srini Fri Jan 10, 2014 12:22 pm

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


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

Back to top Go down

Back to top


 
Permissions in this forum:
You cannot reply to topics in this forum