Can\'t find what you\'re looking for?
Shop by Price
- $10.34
- $10.35 - $12.34
- $12.35 - $14.34
- $14.35 - $16.34
- $16.35+
Shop pages
- Home page
- Payment
- Delivery
- Customer Service
- About the seller
Need help?
Send an message
Newsletter
Add World of Books to your favourites and receive email newsletters about special promotions! General Interest DB2 SQL Tuning Tips for z/OS Developers
Product Details:
Category: Books ISBN: 0133038467 Title: DB2 SQL Tuning Tips for z/OS Developers The Fast Free Shipping Author: Tony Andrews Publisher: Pearson Education (US) Year Published: 2012 Number of Pages: 160 Book Binding: Paperback Prizes: N/A Book Condition: GOOD SKU: CIN0133038467G Item description The Definitive Solutions-Oriented Guide to IBM® DB2® for z/OS®: Now Fully Updated for Both v9 and v10! The largest database tuning performance gains can often be obtained from tuning application code, and applications that use SQL to retrieve data are the best candidates for tuning. This well-organized, easy-to-understand reference brings together more than 100 SQL-related skills and techniques that any developer can use to build and optimize DB2 applications for consistently superior performance. DB2 tuning expert Tony Andrews (“Tony the Tuner”) draws on more than 20 years of DB2-related experience, empowering you to take performance into your own hands, whether you’re writing new software or tuning existing systems. Tony shows you exactly how to clear bottlenecks, resolve problems, and improve both speed and reliability. This book fully reflects the latest SQL programming best practices for DB2 V9 and DB2 V10 on z/OS: techniques that are taught in no other book and are rarely covered in general DB2 SQL courses. Drawing on his extensive consulting experience and highly praised training with Themis Inc., Tony also presents practical checklists and an invaluable 15-step methodology for optimizing virtually any DB2 application. Coverage includes Empowering developers on knowing what to do and where to look in resolving performance problems in queries or programs Providing many programming and SQL coding examples Establishing standards and guidelines that lead to high-performance SQL Implementing time-efficient code walkthroughs to ensure that your standards are followed Focusing on the small number of SQL statements that consume the most resources Identifying simple solutions that deliver the most sizable benefits Optimizing performance by rewriting query predicates more efficiently Providing a better understanding of SQL optimization and Runstat statistics Recognizing opportunities to tweak your code more effectively than the Optimizer Optimizing SQL code with COBOL applications Efficiently checking for the existence of data, rows, or tables Using Runstats’ newest capabilities to consistently optimize paths to data
Please note, the image is for illustrative purposes only, actual book cover, binding and edition may vary.
Payment Delivery Customer Service About Us
We only accept payments made through PayPal, either via a credit / debit card or a PayPal account.
The average shipping times for our orders are as follows:
North America: 2-9 Days
If for some reason your order has not arrived within 15 Business days please get in contact with us so that we can help you.
World of Books USA offer a hassle free money back guarantee for your product, (excluding shipping & handling). We are committed to ensuring each customer is entirely satisfied with their purchase and our service. If you have any issues or concerns, please contact our customer service team within 60 days of purchase and they will be more than happy to help.
World of Books USA was founded in 2005. We offer great value books on a wide range of subjects and we now ship over two million orders each year to satisfied customers throughout the world. We take great pride in our prompt delivery, first class customer service and excellent response.
While we do our best to provide good quality books for you to read, there is no escaping the fact that it has been owned and read by someone else before you. It may well show signs of wear and tear, however each one of our books is hand-checked by our dedicated team for defects before shipping.
World of Books sells quality used products at competitive prices to over 2 million customers worldwide each year. We want your experience with World of Books to be enjoyable and problem free.
Over the past 8 years World of Books has seen the inventory grow from 1000 to over 1 Million books in stock.
We all like the idea of saving a bit of cash, so when we found out how many good quality used products are out there - we just had to let you know! All of our items are checked for quality before they go on sale and we like to think that our prices mean that no item is beyond your budget.
At World of Books we are committed to minimising our environmental impact. Each month we recycle over 2.3 million books, saving over 12,500 metric tonnes of books a year from going straight into landfill sites.
All of our paper waste is recycled within the UK and turned into corrugated cardboard. We believe that it is a travesty to simply throw away a used book or DVD when there is nothing wrong with it - we believe in giving each book or DVD the chance of finding a new home
- Home page
- About us
- response
- Payment
- Delivery
- Customer Service
- Contact us
When you click on links to various merchants on this site and make a purchase, this can result in this site earning a commission. Affiliate programs and affiliations include, but are not limited to, the eBay Partner Network.