|
[SYMBOL]
[A]
[B]
[C]
[D]
[E]
[F]
[G]
[H]
[I]
[J]
[K]
[L]
[M]
[N]
[O]
[P]
[Q]
[R]
[S]
[T]
[U]
[V]
[W]
adding, for joins with hidden join filters combining for tables with hidden join filters complete purge and regrowth pattern for conditions on [See filters; joins; selectivity] full table scan 2nd 3rd 4th 5th large affecting indexed read performance 2nd affecting optimum execution plan 2nd names of, not included in query diagram nodes representing [See nodes] physical layout of, affecting performance selectivity on rows reached from index separating, for one-to-one join to small subset size of cost-based optimizer's response to statistics for, used by cost-based optimizer throughput 2nd [See also performance] transitivity, implying missing join conditions with tuning [See SQL tuning] |