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