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

DB2 V10.5 Tuning of SQL and PL/SQL

View previous topic View next topic Go down

DB2 V10.5 Tuning of SQL and PL/SQL

Post by srini on 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

View user profile

Back to top Go down

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

Post by srini on 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

View user profile

Back to top Go down

View previous topic View next topic Back to top

- Similar topics

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