SQL Tuning [Electronic resources]

entity-relationship diagrams

equality condition, index ranges with

errors [See problem cases]

EXCEPT operation [See set operations]

execution plans 2nd

controlling

cost-based optimizer used for

disabling undesired index

disabling undesired join orders

enabling desired index

enabling desired join order

forcing execution order with subqueries

techniques for

with DB2

with Oracle cost-based optimizer 2nd

with Oracle rule-based optimizer

with SQL Server

DB2

complex

displaying 2nd 3rd

interpreting

multipart

nonrubust

robust

tables for execution-plan data

exercise for 2nd

join order for

calculating cost of

choosing 2nd 3rd

controlling 2nd

for outer joins

optimum

assumptions for

finding 2nd 3rd 4th

for Cartesian products 2nd

for detail join ratios close to 1.0

for detail join ratios less than 1.0

for filter ratios close to each other

for join ratios less than 1.0

for large detail join ratios 2nd

for large root table

for large rowcount returned by query

for master join ratios less than 1.0 2nd

for master join ratios of 1.0

for one large table

for one small filter ratio

for small rowcounts returned

robust execution plans as

special cases for

Oracle

complex

displaying 2nd

interpreting

multipart

nonrobust

robust

table for plan data

parallel 2nd

robust 2nd

creating missing indexes for

improving upon

reasons to choose

SQL Server

complex

displaying 2nd

interpreting

nonrubust

tools for generating 2nd

exercises

creating query diagrams 2nd

diagramming and tuning query with subqueries 2nd

finding optimum execution plan 2nd

EXISTS-type subquery 2nd

execution order when using

replacing INTERSECT

EXPLAIN PLAN FOR statement 2nd

EXPLAIN_ tables

expressions, indexes disabled when using

extents