SQL Tuning [Electronic resources] نسخه متنی

O'Reilly & Associates, Inc., contact information for

one-to-many joins, unintended

one-to-one joins
2nd

online queries, large

optimization levels in DB2

OPTIMIZE FOR ROWS clause

optimizers
[See cost-based optimizer; rule-based optimizer]

Optimizing Oracle Performance (Millsap)

OPTION(FAST 1) hint

OPTION(FORCE ORDER) hint

OPTION(LOOP JOIN) hint

OR operator, indexes disabled when using

Oracle

books about
2nd

cost-based optimizer
2nd
3rd

decoupling index reads from table reads

execution plans

complex

displaying
2nd

interpreting

multipart

nonrobust

robust

table for plan data

extents

function-based indexes

hints used to control queries

index-organized tables

MINUS for EXCEPT operation

notation for filter conditions in joins

null conditions in indexed columns

NVL() function used to disable indexes

optimizers, choosing between

partitioned tables

rule-based optimizer
2nd

TRUNCATE command

type conversions with
2nd

ORDER BY clause
[See ordering]

ORDERED hint

ordering, not included in query diagram

Ouroboros pattern
[See purge eldest pattern]

outer joins
2nd
3rd

abnormal

to detail table

filtered

to filtered detail table

improving performance of, in DB2

join orders disabled when using

leading to inner joins

necessity of ratios for

notation for

optimizing join order for

to views

when to use