Results 1 to 3 of 3

Thread: Index??

  1. #1
    Join Date
    Dec 2008

    Unanswered: Index??

    What is difference between partitioning index and a partitioned index?

  2. #2
    Join Date
    Jan 2007
    Jena, Germany
    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.
    Knut Stolze
    IBM DB2 Analytics Accelerator
    IBM Germany Research & Development

  3. #3
    Join Date
    May 2003
    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.
    M. A. Feldman
    IBM Certified DBA on DB2 for Linux, UNIX, and Windows
    IBM Certified DBA on DB2 for z/OS and OS/390

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts