Dropping indexes on a partitioned table

[tg]

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??

[Ian]

Re: Dropping indexes on a partitioned table

tg wrote:

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.