|
[SYMBOL]
[A]
[B]
[C]
[D]
[E]
[F]
[G]
[H]
[I]
[J]
[K]
[L]
[M]
[N]
[O]
[P]
[Q]
[R]
[S]
[T]
[U]
[V]
[W]
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
|