The Art of SQL

Index

[SYMBOL] [A] [B] [C] [D] [E] [F] [G] [H] [I] [J] [K] [L] [M] [N] [O] [P] [Q] [R] [S] [T] [U] [V] [W] [X]

queries 2nd

     answered by returning index data

     blanket views, performance impact of

     complex, and complex views

     distributed

     distributed and parallelized

     dynamic

         for variable number of search criteria

         mistakes commonly made in

     estimating behavior with increased data volumes

     expression of, association with implicit assumptions about data

     functionally equivalent, comparison to synonyms

     identifying

     improving, what really matters

     limits of the optimizer

     making as fast as possible

     nested

     non-relational aspects of

     number of data page hits by DBMS during performance of

     order of evaluation of conditions

     performance, whole key dependence and

     programming logic into

     relational component

     relational layer, doing maximum work in

     returning a very large amount of data

     rewriting by the optimizer

     size of result set

     SQL expression of

     tuning

     various layers of

query tools