Index_E

---

E

Employees schema, 73, 81–82, 88

ERD version,

one, 696

two, 697

Enterprise Manager Diagnostics Pack, 625–34

Enterprise Manager Tuning Pack, 365–84

Index Tuning Wizard, 365–72

select schemas, 369

select the application type, 368

wizard recommendations, 370

Oracle Expert, 380–82

Optimizer query plans, 381–82

recommendations for the Accounts schema, 383

SQL Access Advisor, 382

SQL Analyze, 372–80

analysis stage, 373

comparing different versions, 380

index recommendations, 377

query plan, 376

query plan assessment, 378

SQL statement assessment, 374

SQL text display, 375

virtual indexing, hints, and tuning, 379

and Wait Event Interface, 665–69

EXPLAIN PLAN:

sample script, 719–20

use to detect problem queries, 16, 328–35

---