| < Day Day Up > |
|
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 > |
|