• 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] nested-loops joins 2nd in DB2 execution plan forcing use of 2nd 3rd in Oracle execution plan in SQL Server execution plan when to use 2nd nodescloud of in query diagrams unnecessary, in queries with views nonunderlined numbers in query diagrams nonunique indexes, performance effects of normal form, query diagrams matching normalized data 2nd [See also denormalized data]3rd NOT EXISTS-type subquery 2nd 3rd null valuesdatabase interpretation of in indexes 2nd 3rd numbers in query diagrams 2nd 3rd [See also filter ratio; join ratio]NVL() function |
لطفا منتظر باشید ...
