Index??

denisvenis · #1 (**permalink**) 10-13-09, 10:53

What is difference between partitioning index and a partitioned index?

stolze · #2 (**permalink**) 10-13-09, 13:19

The first determines the partitioning of the data in the table. It does not have to be partitioned by itself, I believe. The second is an index that is itself partitioned, possibly along a completely different partitioning criteria.

Marcus_A · #3 (**permalink**) 10-13-09, 13:53

In V9.7 table partitioning, indexes can be partitioned so there is not one global index across all the partitions. This speeds up detaching a partition, otherwise a global index would have to be updated for the rows that were detached.

Internet Services

Web Development

Digital Marketing

Consumer Tech