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

I/O (Input/Output)

logical
2nd
3rd
4th

physical
2nd
3rd

icons used in this book

IN condition, execution order when using

index blocks
2nd
3rd
4th

index range scan
2nd

index range-condition selectivity

INDEX() hint

index-organized tables

INDEX_DESC() hint

indexed table access

in DB2 execution plan

in Oracle execution plan

in SQL Server execution plan

when to use

indexes
2nd
3rd

adding for specific queries

adding, effects on performance

B-tree indexes
2nd

bit-mapped indexes

combining

date-type columns in

disabling use of

dropping, risks of

enabling use of

forcing use in descending order

forcing use of specific index
2nd

full index scan
2nd

function-based

with merged join key and filter columns

missing
2nd
3rd

rowids used by

satisfying query without accessing database

selectivity on rows reached from

size of

caching and
2nd

cost-based optimizer's response to

statistics for, used by cost-based optimizer

updating, performance effects of

individual-condition filter selectivity
2nd

inequality condition, index ranges with
2nd

inner joins
2nd
3rd

Input/Output
[See I/O]

inserts into index, performance effects of

INTERSECT operation
[See set operations]

italic font used in this book
2nd