Index_I

 < Day Day Up > 



I

Indexing, 199–235, 721–22

alternate or secondary indexing, 202–3

Index Tuning Wizard, 365–72

select schemas, 369

select the application type, 368

wizard recommendations, 370

sample scripts, 721–22

types of index in Oracle database, 203–20

bitmap indexes (see Bitmap indexes)

BTree index (see BTree indexes)

clusters, 219–20

read only index, 209

syntax, 205–6

using referential integrity, 201–2

what and how to index, 199–200

when not to use indexes, 200–201

Installing Oracle database, 387–405

archiving, 401

auditing and tracing, 399–401

basic network files, 389

configuring the client, 390–91

configuring the listener, 389–90

block size, 392

check pointing, 401

control files, 392

job scheduling, 403–4

memory buffers and I/O behavior, 393–98

connection memory requirements, 395–96

database buffer cache, 393–94

Java pool, 397

large pool, 396–97

radio log buffer cache, 397–98

shared pool, 394–95

networking, 404–5

parameter file, 391–92

resource management, 403

rollback and undo, 402–3

SQL code Optimization, 398–99

using different editions, 388



 < Day Day Up > 



Oracle High Performance Tuning for 9i and 10g
Oracle High Performance Tuning for 9i and 10g
ISBN: 1555583059
EAN: 2147483647
Year: 2003
Pages: 164

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net