Dropping indexes on a partitioned table

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

tg - 26 Sep 2008 03:17 GMT

Indexes cause inserts/load to slow down. Is there anyway to drop
indexes on one partition of a partioned table? From what I read this
is not possible. I know Oracle has the option to disable local
indexes. Is there anything similar in db2??

Reply to this Message

Ian - 26 Sep 2008 20:06 GMT

> Indexes cause inserts/load to slow down. Is there anyway to drop
> indexes on one partition of a partioned table? From what I read this
> is not possible. I know Oracle has the option to disable local
> indexes. Is there anything similar in db2??

If you're talking about range-partitioned tables, DB2 only has global
indexes.

If you detach a partition into a table, that table will *not* have the
indexes defined on the partitioned table.

So you could detach the partition, load the data, and then reattach the
partition.

Reply to this Message