Index creation in multiple tablespaces in db2

Go To


I have a basic question. In db2, is it possible to create an index which resides in multiple table spaces? Just like we can create a partitioned table in multiple tablespaces?

I tried a couple of links from IBM.

Is there a way we can make an index reside in multiple tablespaces?

Any help is appreciated.


2012-04-04 04:56
by Ricketyship


In short, yes. FYI, the page that you linked to provides the answer to your question.

When you create a partitioned index on a range-partitioned table, the index partition for each table partition can reside in a different tablespace. See Figure 3 for a picture of how this looks.

2012-04-04 21:43
by Ian Bjorhovde