Oracle Data Warehouse Tuning for 10g
Taking users beyond the basics to critical issues in running the most efficient data warehouse applications, this book illustrates how to keep data going in and out in the most productive way possible.
TABLE OF CONTENTS Oracle Data Warehouse Tuning for 10g
Index
Numbers
1st normal form, 4
2nd normal form, 4, 5
3rd normal form, 4 5, 6
query optimization, 44
schemas, 44
4th normal form, 5
5th normal form, 6
A
Abstraction, 12
Aggregated materialized views, 128
Aggregations, 46 47, 327 28
application of, 115
cumulative, 262
fast refresh requirements, 93 94
GROUP BY clause, 169
GROUP BY clause extensions, 215 47
HAVING clause, 169 70
joins and, 97
physical space, 80
precalculation, 80
processing, 80
query rewrite performance and, 332 33
single table, 101
Aliases, 188
ALTER DIMENSION statement, 123
ALTER INDEX statement, 343
ALTER MATERIALIZED VIEW [LOG] statements, 90, 91
Alternate indexing, 53 54
defined, 53
disadvantages, 54
excessive, 54
need for, 53
See also Indexes; Indexing
ALTER TABLESPACE statement, 367
Analysis, 46 47
Analysis reporting, 249 79
analytical functions, 253 56
categories, 251 53
data densification, 252
defined, 249
equiwidth histograms, 252
first and last, 252
frequent itemsets, 252
hypothetical ranks and distributions, 252
inverse percentiles, 252
lag and lead, 251
linear regressions, 252
moving windows, 251, 261 62
objective, 249
performance and, 251
in practice, 270 79
rankings, 251
specialized expressions, 252
specialized statistical functions, 253
specialized syntax, 256 70
Analytical functions, 253 56
aggregation, allowing analysis, 256
lag and lead, 255
ranking, 255
statistical, 253 54
statistical distribution, 254 55
summary, 253
Angle brackets (<...>), 447
Anti comparison condition, 173
Anti-joins, 41, 180
ANY wildcard, 299, 300
Appending, 353
direct load, 354
space reuse and, 353
Archive logs
defined, 397
tuning, 399 402
See also Redo logs
Attributes, 12
Automated undo tablespace, 408
B
Bitmap indexes, 40, 58 61
block level locking,...
Copyright Elsevier Inc. 2005 under license agreement with Books24x7
