Query Strategies

  • Jason Strate
  • Grant Fritchey

Abstract

In the previous chapter, you looked at strategies to identify potential indexes for your databases. That, though, is often only half 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

Data Type Scalar Function Query Result Execution Plan Query Optimizer 
These keywords were added by machine and not by the authors. This process is experimental and the keywords may be updated as the learning algorithm improves.

Supplementary material

978-1-4842-1118-2_12_MOESM1_ESM.zip (10 kb)
Performance Indexing - Chapter 12 - Query Strategies.zip (zip 11 kb)

Copyright information

© Jason Strate and Grant Fritchey 2015

Authors and Affiliations

  • Jason Strate
    • 1
  • Grant Fritchey
    • 1
  1. 1.MNUS

Personalised recommendations