Index_O

---

O

Object tuning, 453–66 see also Indexing

caching, 453–54

deallocating unused space, 459

dropping columns, 458–59

fragmentation and coalescing of indexes, 462

index-organized tables and clusters, 462–63

index parallelism, 461–62

logging, 454

monitoring indexes, 459–61

recycle bin, 465

sequences, 463

storing LOBs separately, 457–58

synonyms and views, 464–65

table parallelism, 454–57

Online Transaction Processing (OLTP), definition, xiii

Optimization, 239–56, 313–26

cost-based, 246–47

defined, 239–40

outlines, 244

overriding using hints, 313–26

change index scans, 319–22

change joins, 322–24

change queries and subqueries, 325

change table scans, 318–19

classifying hints, 316

influence the Optimizer, 317–18

other hints, 325–26

parallel SQL, 324–25

rule-based, 243–45

setting the mode, 242–43

and statistics, 247–55

ANALYZE command, 250–52

generation, 248–50, 720–21

histograms, 253–55

use of hints, 244–45

Oracle:

and BTree index, 207

and Denormalization, 79–80

Enterprise Manager,

Diagnostics Pack, 625–34

Tuning Pack, 365–84, 388

and Wait Event Interface, 665–69

Expert, 380–82

Optimizer query plans, 381–82

recommendations for the Accounts schema, 383

Oracle Database 10 Grid  database, 22–23, 387, 388

history, 94–96

9i database, 387

installation (see Installing Oracle database)

Instance, 427–30

making SQL efficient, 237–327

Metalink, 727

networking software (see SQL*Net)

partitioning, 545–55

software, xi, 22

Spotlight on Oracle, 634–36, 637, 638

Technet, 727

tuning requirements, 1–24

types of indexes, 203–20

Wait Event Interface tuning, 647–94

---