Query Strategies

  • Jason Strate
  • Ted Krueger

Abstract

In the last chapter, you looked at strategies to identify potential indexes for your databases. That, though, is often only half of the story. Once the indexes have been created, you would expect performance within the database to improve, leading you then to the next bottleneck. Unfortunately, coding practices and selectivity can sometimes negatively influence the application of indexes to queries. And sometimes how the database and tables are being accessed will prevent the use of some of the most beneficial indexes in your databases.

Keywords

Havoc 

Preview

Unable to display preview. Download preview PDF.

Unable to display preview. Download preview PDF.

Copyright information

© Jason Strate and Ted Krueger 2012

Authors and Affiliations

  • Jason Strate
  • Ted Krueger

There are no affiliations available

Personalised recommendations