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]
nested- loops joins 2nd in DB2 execution plan forcing use of 2nd 3rd in Oracle execution plan in SQL Server execution plan when to use 2nd nodes cloud of in query diagrams unnecessary, in queries with views nonunderlined numbers in query diagrams nonunique indexes, performance effects of normal form, query diagrams matching normalized data 2nd [See also denormalized data]3rd NOT EXISTS-type subquery 2nd 3rd null values database interpretation of in indexes 2nd 3rd numbers in query diagrams 2nd 3rd [See also filter ratio; join ratio] NVL() function
|