Index S


[SYMBOL] [A] [B] [C] [D] [E] [F] [G] [H] [I] [J] [K] [L] [M] [N] [O] [P] [Q] [R] [S] [T] [U] [V] [W]

select lists, not included in query diagrams  
selectivity  
       index range-condition selectivity  
       of filters  
       on table rows reached from index  
self-caching   2nd  
semi-join   2nd  
set operations, queries using  
simple queries  
       creating query diagrams for  
       criteria for  
       full query diagrams for  
       interpreting query diagrams for  
       simplified query diagrams for  
simplified query diagrams   2nd   3rd  
single-table access paths  
single-table clusters  
single-table queries  
software   [See also application; middleware]
software tools for generating execution plans   2nd  
sort -merge joins   2nd  
       in DB2 execution plan  
       in Oracle execution plan  
       when to use   2nd  
SQL Server
       COALESCE() function  
       execution plans
               complex  
               controlling  
               displaying   2nd  
               interpreting  
               nonrobust  
       FORCEPLAN option  
       modifying queries with  
       type conversions with  
SQL Server Query Analyzer   2nd   3rd  
       example of using  
       updating statistics in  
SQL statements   [See queries]
SQL tuning   [See also execution plans; problem cases]
       example of process  
               altering application as necessary  
               altering database as necessary  
               altering query as necessary  
               checking existing execution plans  
               creating query diagram  
               finding best execution plan  
       improvement percentage requirements  
       reasons for  
       steps for  
       types of solutions for  
       who should perform   2nd  
SQL, book about   2nd   [See also queries]
statistics
       providing for cost-based optimizer  
       updating for Oracle  
       updating with DB2  
       updating with SQL Server  
subqueries  
       converting existence checks to  
       correlated, forcing evaluation of  
       DB2 execution plan for  
       exercise for   2nd  
       EXISTS subqueries   2nd   3rd   4th  
       forcing execution order when using  
       NOT EXISTS subqueries   2nd   3rd  
       Oracle execution plan for  
       query diagrams for  
       SQL Server execution plan for  
       tuning  
subquery adjusted filter ratio   2nd   3rd  
subquery root detail table  
Sybase   [See also SQL Server]
       execution plans for  
       FORCEPLAN option  



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