Index
A
outer-join-to-inner transformation
calling code, data dictionary query
suboptimal plan, data dictionary view
Auto DOP. See Automatic degree of parallelism (auto DOP)
B
C
PAYGRADE and PAYMENT_DATE correlation
simple cardinality and bytes calculation
D
E
controlling parallel execution
creating tables and loopback database link
SH example schema and cursor cache
INLIST ITERATOR and PARTITION RANGE operators
operation 2: TABLE ACCESS FULL
operations 4 and 5: TABLE FULL SCANs
parallel query server sets and DFO trees
F
G
H
documented versus undocumented
optimizer hints (see Optimizer hints)
I
J, K, L
nested loops (see Nested loops)
parallel joins (see Parallel joins)
M
N
Non-sorting aggregate functions
index range and index full scans (see Index range and index full scans)
O
purpose (see Full table scan (FTS))
and subpartition-level statistics
Object statistics and deployment
gathering statistics, execution plans
generating false object statistics
transforming SQL code and adding hints
Oracle’s plan stability features
performance management, principle
column statistics (see Column statistics)
DBMS_STATS.COPY_TABLE_STATS (see DBMS_STATS.COPY_TABLE_STATS)
P
required indexes identification
multi-column non-unique indexes, correct use
Q
R
operational level data, display
ALL executions of a statement vs. operation
operation level data, collection
optimal, one-pass, and multipass operations
Snapper, session level statistics
DBMS_SQLTUNE.REPORT_SQL_MONITOR
V$SQL_PLAN_STATISICS_ALL, drawbacks
S
Sort optimization. See also Data densification
adding additional predicates, optimize analytics
first attempt at moving average
inefficient implementation, SALES_ANALYTICS
lateral joins, data dictionary types
lateral joins with one dimension table
lateral joins with two dimension tables
non-sorting aggregate functions (see Non-sorting aggregate functions)
GROUP BY and analytic functions
non-sorting (see Non-sorting aggregate functions (NSAFs))
T
U, V, W, X, Y, Z
18.222.182.66