Drop Index

I am trying to drop an index on a table prior to compression. However, the process is taking considerably longer than expected, and too long for the outage I have. Does anyone know what parameters I could change to speed up the index drop - it will be the only process running. I already change the following .... Buffers from 1750000 to 2800000 LRU's from 28 to 128 RA_PAGES from 16 to 64 RA_THRESHOLD from 10 to 32 CLEANERS from 60 to 128This is on a database running 11.50. Table is 16million pages in size, with the index attached and in the same dbspace.

Hi, If it's me, i'll do full backup the instance and set it to "no logging". Then, perform a drop index. (this is assuming, you have a maintenance window).

When you say "attached" I get a bit confused... By default, 11.50 does not create attached indexes. Was it created in a previous version (prior to 9.40 I believe)? Or do you have the variable DEFAULT_ATTACH set in the environment? Depending on the table size, other indexes, maintenance window and hardware you could consider duplicating the table (without that index) Removing an attached index is always very slow.... as opposed to a detached index that should be almost instantaneous. Regards. On Wed, Jan 25, 2012 at 10:03 AM, JIM GODDEN <jim.godden@orange.co.uk>wrote: > I am trying to drop an index on a table prior to compression. However, the > process is taking considerably longer than expected, and too long for the > outage I have. Does anyone know what parameters I could change to speed up > the > index drop - it will be the only process running. I already change the > following .... > Buffers from 1750000 to 2800000 > LRU's from 28 to 128 > RA_PAGES from 16 to 64 > RA_THRESHOLD from 10 to 32 > CLEANERS from 60 to 128> This is on a database running 11.50. Table is 16million pages in size, with > the index attached and in the same dbspace. > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > -- Fernando Nunes Portugal http://informix-technology.blogspot.com My email works... but I don't check it frequently... --20cf300faebb624d9604b7592579