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