Index M


[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]



SQL Tuning
SQL Tuning
ISBN: 0596005733
EAN: 2147483647
Year: 2003
Pages: 110
Authors: Dan Tow

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net