Re: How can I speed up the 'drop index' command?

I have a question related to this matter: I found out that IDS.2000 keeps each attached index in a separate tablespace. Could this feature help on the speed of dropping an index? TIA Cristian. duane_hakala@my-deja.com wrote: > > I'm copying tables from one disk to another (faster disks, extent > consolidation). I rename the old tables to keep them around for a few > days until I'm sure the copies are okay. > > I have to create indexes on the new copy using the same names as the > indexes on the old table, so I have to drop the indexes on the old > table first. Some of the tables are > 2Gb in size and have 5+ indexes - > is there any way to speed up dropping the old indexes? Anything I can > change in my onconfig file? > > TIA > > Duane > > Sent via Deja.com http://www.deja.com/ > Before you buy.