Physical Database Design

Index 421

biasing, 216

capturing, 213

cost estimation, 46

in database design improvement,

205–11

data size/distribution and, 215

defined, 41

development, 41–43

Explain, 201–5

exploring without changing data-

base, 214–15

hints, 33

for join of parts table, 207

joins executed first, 48

with materialized view, 209

physical design and, 197–220

query cost evaluation example, 37,

39

for range query, 212

restructuring algorithm, 42–43

selections executed first, 48

summary, 220

table sizes, example estimations,

49–50

tips/insights, 219–20

transformation rules, 42

viewing, 33

without materialized view, 209

Query hints, 216–19

adding, 216

defined, 216

example, 216–17

Oracle, 217–19

when SQL not available, 219

Query I/O time, 82

Query optimization, 31–34

defined, 32

depth, 34

features, 32–34 ...