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
- || (concatenate), Problem 1: Statement Not Written for Indexes
B
- bind variables, Encourage Bind Variables
C
- casting, Problem 1: Statement Not Written for Indexes
- columns
- type conversion, Problem 1: Statement Not Written for Indexes
- concatenate, Problem 1: Statement Not Written for Indexes
- conversion
- index column types, Problem 1: Statement Not Written for Indexes
D
- DECODE, Use DECODE for IF/ELSE Selection
I
- indexes
- type conversion, Problem 1: Statement Not Written for Indexes
O
- optimizer
- cost-based, Understanding the Cost-Based Optimizer
- rule-based, The SQL Optimizers
- ORDER BY
- condition ranking, Understanding the Rule-Based Optimizer
R
- ROWID
- condition ranking, Understanding the Rule-Based Optimizer
S
- SELECT
- WHERE clause, Problem 3: Incorrect Driving Index
- SUBSTR, Problem 1: Statement Not Written for Indexes
V
- variables
- bind, Encourage Bind Variables
W
- WHERE
- efficiency, Problem 3: Incorrect Driving Index
- indexes not used in some cases, Problem 1: Statement Not Written for Indexes
- sequence, ...
Get Oracle SQL Tuning Pocket Reference now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.