470,822 Members | 1,222 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 470,822 developers. It's quick & easy.

Partitioned table and its indexes

Hello all!
I created a range-partitioned table, and noticed that indexes were created
as "NOT PARTITIONED" (through db2look), even though I ran the index creating
commands without this parameter.
Not that I care too much now about it :-)
But what will happen when once upon a time in the future I execute the
"attach partition" command, and so add another partition to the existing
(partitioned) table.
Will the indexes then be automatically rebuilt, or do I have to do it myself
(perhaps by executing the "set integrity" command), or else...?

Another question: can I at all have a partitioned table where each table
partition has its own "index-partition", and does this make any sense at all
(why partition the index) and in what way (performance improvements, ...)?

Jun 27 '08 #1
0 1480

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

3 posts views Thread by Thomas R. Hummel | last post: by
11 posts views Thread by steve.keanie | last post: by
10 posts views Thread by shsandeep | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.