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.)

Kali Linux Wireless Penetration Testing Essentials
Kali Linux Wireless Penetration Testing Essentials

Plan and execute penetration tests on wireless networks with the Kali Linux distribution

About This Book

  • Learn the fundamentals of wireless LAN security and penetration testing
  • Discover and attack wireless networks using specialized Kali Linux tools
  • A step-by-step,...
Windows Phone 7 Developer Guide: Building connected mobile applications with Microsoft Silverlight
Windows Phone 7 Developer Guide: Building connected mobile applications with Microsoft Silverlight

Great achievements don’t happen overnight—they evolve over time based on a series of successes that converge and drive you onward. My favorite soccer team, Seattle Sounders FC, started life way back in 1974 in the North American Soccer League and only achieved their recent success in Major League Soccer through working hard to...

Adobe Acrobat 8 in the Office
Adobe Acrobat 8 in the Office
Adobe Acrobat is one of the most widely recognized tools for document management, office communications, and improved workflow, and Acrobat 8 is the most powerful version yet, introducing new tools for shared reviews, creating automated forms, license management, additional security, and many others. Now that PDF has become the ubiquitous...

Biosignal and Biomedical Image Processing
Biosignal and Biomedical Image Processing
Relying heavily on MATLAB® problems and examples, as well as simulated data, this text/reference surveys a vast array of signal and image processing tools for biomedical applications, providing a working knowledge of the technologies addressed while showcasing valuable implementation procedures, common pitfalls, and essential application...
Network Graph Analysis and Visualization with Gephi
Network Graph Analysis and Visualization with Gephi

Visualize and analyze your data swiftly using dynamic network graphs built with Gephi

Overview

  • Use your own data to create network graphs displaying complex relationships between several types of data elements
  • Learn about nodes and edges, and customize your graphs using size, color, and...
AIDS in South Asia: Understanding And Responding to a Heterogenous Epidemic (Health, Nutrition, and Population Series)
AIDS in South Asia: Understanding And Responding to a Heterogenous Epidemic (Health, Nutrition, and Population Series)

South Asia's HIV epidemic is highly heterogeneous. As a result, informed, prioritized, and effective responses necessitate an understanding of the epidemic diversity between and within countries. Further spread of HIV in South Asia is preventable. The future size of South Asia's epidemic will depend on an effective two-pronged...

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