Using Partitioned Indexes in Data Warehousing and DSS Applications

Here are a few guidelines for data warehousing and DSS applications:
■ Local indexes are preferable because they are easier to manage during data loads
and during partition-maintenance operations.
■ Local indexes can improve performance because many index partitions can be
scanned in parallel by range queries on the index key.

在資料載入和分割槽維護操作情況較多的情況下，本地索引更加合適
在索引鍵的範圍內查詢時，本地索引可改進效能，因為許多索引分割槽能被並行掃描

[@more@]