Home | Amazing | Today | Tags | Publishers | Years | Account | Search 
SQL Tuning

Buy
SQL Tuning, 9780596005733 (0596005733), O'Reilly, 2003
SQL Tuning author Dan Tow outlines a timesaving method he's developed for finding the optimum execution plan--rapidly and systematically--regardless of the complexity of the SQL or the database platform being used. You'll learn how to understand and control SQL execution plans and how to diagram SQL queries to deduce the best execution plan for a query. Key chapters in the book includes exercises to reinforce the concepts you've learned. SQL Tuning concludes by addressing special concerns and unique solutions to "unsolvable" problems.

More than 10 years ago, I came to understand that the biggest factor in the performance of a business application is the speed of the SQL it runs. It took me longer to realize just how much room for improvement typically lies in that SQL. The SQL that most effects the load on a system and the productivity of its end users can usually be improved by a large factor, usually by a factor of two or more. However, I found little guidance regarding just how to tune SQL. I believe that problem persists today.

Academic journals describe detailed methods that are suitable for automated optimization, but these methods are not adapted for manual tuning. Documentation for the practitioner, so far as I've seen, is incomplete. Database vendors and independent authors document well how to review the path the database takes to reach the data. (The path to the data is known as the execution plan.) Armed with the execution plan, you can understand why a query runs as long as it does. With varied success, the documentation also covers what you can do to change an execution plan, if you suspect that it is not optimal. The missing part in the literature is a detailed manual process to deduce, without endless trial and error, exactly which execution plan you should want. Since real business-application queries can easily offer billions of alternative execution plans, tuning without a systematic method to choose your target execution plan is hopelessly inefficient. The problem is akin to finding yourself lost in a strange city without a map: working eyes and legs are not enough to take you where you need to go.

The missing piece of the problem, how to choose the best execution plan, turns out to be virtually independent of your choice of  database vendor. This presents a wonderful opportunity for a single book on SQL tuning that is 80% vendor-independent, because 80% of the book has nothing to do with the uninteresting details of viewing and manipulating execution plans with vendor-specific methods. I wrote this book to fulfill that opportunity and to enable you to approach SQL tuning with this powerful, vendor-independent approach.

(HTML tags aren't allowed.)

Network Security Technologies and Solutions (CCIE Professional Development Series)
Network Security Technologies and Solutions (CCIE Professional Development Series)
Yusuf Bhaiji, CCIE No. 9305 (R&S and Security), has been with Cisco for seven years and is currently the program manager for Cisco CCIE Security certification. He is also the CCIE Proctor in the Cisco Dubai Lab. Prior to this, he was technical lead for the Sydney TAC Security and VPN team at Cisco.
  • Filter traffic with access...
Microscope Image Processing
Microscope Image Processing
Digital image processing is an integral part of microscopy and is increasingly important to the fields of medicine and scientific research. This book provides a unique one-stop reference on the theory, techniques and applications of this technology.

Written by leading experts in the field, the book presents a unique practical perspective
...
From Object-Orientation to Formal Methods: Essays in Memory of Ole-Johan Dahl (Lecture Notes in Computer Science)
From Object-Orientation to Formal Methods: Essays in Memory of Ole-Johan Dahl (Lecture Notes in Computer Science)
This book is dedicated to the memory of Ole-Johan Dahl who passed away in June 2002 at the age of 70, shortly after he had received, together with his colleague Kristen Nygaard, the ACM Alan M. Turing Award:

"For ideas fundamental to the emergence of object-oriented programming, through their design of the programming languages Simula I...


Monitoring and Managing Microsoft Exchange 2000 Server (HP Technologies)
Monitoring and Managing Microsoft Exchange 2000 Server (HP Technologies)

Monitoring and Managing Microsoft Exchange 2000 Server focuses on what to do after Exchange has been deployed—how to design and implement the support infrastructure, how to monitor and manage messaging traffic, and how to avoid disaster through proactive planning and management. ...

Building Apps for the Universal Windows Platform: Explore Windows 10 Native, IoT, HoloLens, and Xamarin
Building Apps for the Universal Windows Platform: Explore Windows 10 Native, IoT, HoloLens, and Xamarin

Develop Windows 10 applications faster and more efficiently using the Universal Windows Platform. You will use Xamarin to create apps for macOS, iOS, and Android devices.

Building Apps for the Universal Windows Platform is a complete guide covering PCs, tablets, phones, and other devices such as HoloLens. You...

150 Best Jobs for Your Skills (Jist's Best Jobs)
150 Best Jobs for Your Skills (Jist's Best Jobs)

150 Best Jobs for Your Skills identifies the top ten skills that are the most important in today’s economy, based on data from the U.S. Department of Labor and the latest O*NET. It helps job seekers find a fulfilling job and students explore their future career options by focusing on the 50 most promising jobs for each skill. It...

©2019 LearnIT (support@pdfchm.net) - Privacy Policy