O'Reilly logo

SQL Tuning by Dan Tow

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Index

A note on the digital index

A link in an index entry is displayed as the section title in which that entry appears. Because some sections have multiple index markers, it is not unusual for an entry to have several links to the same section. Clicking on any link will take you directly to the place in the text in which the marker appears.

Symbols

() (parentheses)
in FROM clause for DB2, Prevent too many outer joins from parsing at once
surrounding ordered list of items, Conventions Used in This Book
+ (plus sign)
in comment, General hint syntax
in join clause, Filtered outer joins
<> (angle brackets), surrounding missing portions of SQL statement, Conventions Used in This Book
“E” in query diagram, Diagramming EXISTS subqueries
“F” in query diagrams, Simplified Query Diagrams
“f” in query diagrams, Simplified Query Diagrams
“R”, in query diagram, Underlined numbers

A

aggregation, Ordering and aggregation, Glossary
(see also grouping; post-group filtering)
not included in query diagrams, Ordering and aggregation
queries aggregating too many rows, Unsolvable Problems, Aggregations of Many Details
in reports, Report information types, Report information types
ALL_ROWS hint, Approaches to tuning with hints
AND-EQUAL MERGE operation, Combining Indexes
angle brackets (<>), surrounding missing portions of SQL statement, Conventions Used in This Book
anti-join, Diagramming NOT EXISTS subqueries, Glossary
apples-and-oranges tables, Glossary
application, Why Tune SQL?
(see also queries)
altering, determining necessity ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required