Oracle9iR2 Data Warehousing

I

Incremental backups, 352–53

defined, 352

level, 352–53

selecting, 353

See also Backup(s)

Independent data marts, 9

Indexes, 28, 51–52

bitmap, 70–73

bitmap join, 73–76

b*tree, 69–70

building block, 68

changes, 377–78

drop, 242

Easy Shopping Inc., 61–65

global, 88–89

local, 90–92

maintenance, deferring, 236

Oracle Enterprise Manager, 52

partitioned, 88–92

partitions, 372

planning, 52

selection, 51

types of, 51, 68

unstable, checking for, 246–47

unstable, rebuilding, 247

Indexing, 68–76

decisions, 68

materialized views, 147

needs, understanding, 68

Index Tuning Wizard, 383

INSERT SELECT statement, 248

INSERT statement, 298

Integrating data, 221

Internet, 399–401

Intranet, 399–401

contents example, 400

defined, 399

Inverse percentile, 123–24

Items

calculated, creating, 312

classes, 313–14

creating, 311–12

defined, 310

details, changing, 310–11