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