SQL Tuning [Electronic resources] نسخه متنی

select lists, not included in query diagrams

selectivity

index range-condition selectivity

of filters

on table rows reached from index

self-caching
2nd

semi-join
2nd

set operations, queries using

simple queries

creating query diagrams for

criteria for

full query diagrams for

interpreting query diagrams for

simplified query diagrams for

simplified query diagrams
2nd
3rd

single-table access paths

single-table clusters

single-table queries

software
[See also application; middleware]

software tools for generating execution plans
2nd

sort-merge joins
2nd

in DB2 execution plan

in Oracle execution plan

when to use
2nd

SQL Server

COALESCE() function

execution plans

complex

controlling

displaying
2nd

interpreting

nonrobust

FORCEPLAN option

modifying queries with

type conversions with

SQL Server Query Analyzer
2nd
3rd

example of using

updating statistics in

SQL statements
[See queries]

SQL tuning
[See also execution plans; problem cases]

example of process

altering application as necessary

altering database as necessary

altering query as necessary

checking existing execution plans

creating query diagram

finding best execution plan

improvement percentage requirements

reasons for

steps for

types of solutions for

who should perform
2nd

SQL, book about
2nd
[See also queries]

statistics

providing for cost-based optimizer

updating for Oracle

updating with DB2

updating with SQL Server

subqueries

converting existence checks to

correlated, forcing evaluation of

DB2 execution plan for

exercise for
2nd

EXISTS subqueries
2nd
3rd
4th

forcing execution order when using

NOT EXISTS subqueries
2nd
3rd

Oracle execution plan for

query diagrams for

SQL Server execution plan for

tuning

subquery adjusted filter ratio
2nd
3rd

subquery root detail table

Sybase
[See also SQL Server]

execution plans for

FORCEPLAN option