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]
many-to-one join master join ratio 2nd equal to 1.0, affecting optimum execution plan example of less than 1.0, affecting optimum execution plan 2nd shortcuts for master table Mastering Oracle SQL (Mishra; Beaulieu) memory-only data access [See pure logical I/O] merge joins [See sort -merge joins] merged join and filter indexes Microsoft SQL Server [See SQL Server] middleware 2nd 3rd Millsap, Cary (Optimizing Oracle Performance) MINUS operation [See set operations] Mishra, Sanjay (Mastering Oracle SQL) most recently used blocks [See MRU blocks] MRU (most recently used) blocks multipart execution plans multipart joins multiple-condition filter selectivity 2nd multitable clusters multitable queries join execution methods for joins for 3rd [See also complex query]
|