
14.3 Capacity Planning 409
Chapter 14
Compressing Objects
Objects such as tables and indexes can be compressed. As for index com-
pression, table compression tends to remove duplicate values, such as
repeated foreign key indexes on fact tables. Also, note that table compres-
sion filters through to materialized views.
14.3 Capacity Planning
Capacity planning involves two main subject areas: current storage space
usage and potential growth. Remember that for a data warehouse, through-
put is more important than concurrent reaction time, as in an OLTP data-
base. In other words, lots and lots of processing in the form of very large
transactions, such as large ...