Nonpartitioned and Partitioned - wykład

Nonpartitioned and Partitioned
As with tables, you can partition an index. In most situations, it is useful to partition
an index when the associated table is partitioned, and to partition the index using the
same partitioning scheme as the table. (For example, if the table is range-partitioned
by sales date, then you create an index on sales date and partition the index using the
same ranges as the table partitions.) This is known as a local partitioned index.
However, you do not have to partition an index using the same partitioning scheme as
its table. You can also create a nonpartitioned, or global, index on a partitioned table.
... zobacz całą notatkę