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.