• Table of Contents• Index• Reviews• Examples• Reader Reviews• Errata• AcademicSQL TuningBy
Publisher: OReillyPub Date: November 2003ISBN: 0-596-00573-3Pages: 336
SQL Tuning author Dan Tow outlines a
timesaving method hes developed for finding the optimum
execution plan--rapidly and systematically--regardless of
the complexity of the SQL or the database platform being
used. Youll learn how to understand and control SQL
execution plans and how to diagram SQL queries to deduce the
best execution plan for a query. Key chapters in the book
includes exercises to reinforce the concepts youve learned.
SQL Tuning concludes by addressing
special concerns and unique solutions to "unsolvable"
problems.
[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 queriesjoin execution methods for joins for 3rd [See also complex query] |
لطفا منتظر باشید ...
