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

tables

adding, for joins with hidden join filters

aliases of, in query diagrams

apples-and-oranges tables

combining

for exact one-to-one joins

for tables with hidden join filters

complete purge and regrowth pattern for

conditions on
[See filters; joins; selectivity]

continuous growth pattern for

detail table

driving
2nd
3rd
4th
5th
6th

focus table

full table scan
2nd
3rd
4th
5th

growth patterns for

high-water mark of
2nd
3rd

index-organized

indexed access of
2nd
3rd
4th

large

affecting caching
2nd

affecting indexed read performance
2nd

affecting optimum execution plan
2nd

nested loops for

master table

multitable clusters

multitable queries

names of, not included in query diagram

nodes representing
[See nodes]

partitioned

physical layout of, affecting performance

purge eldest pattern for

purge, not by age pattern for

root detail table

selectivity on rows reached from index

separating, for one-to-one join to small subset

single-table access paths

single-table clusters

single-table queries

size of

cost-based optimizer's response to

indicating necessity of index

represented in query diagrams

small, affecting caching

statistics for, used by cost-based optimizer

throughput
2nd
[See also performance]

TOAD software tool

transitivity, implying missing join conditions with

TRUNCATE command

tuning
[See SQL tuning]

tuple

two-node filter
2nd

type conversions, indexes enabled and disabled by
2nd