Re: Deleting Question

Bill, We are running V7.11 and I have never heard of such a facility. Nor can I find any indication in the manuals about this capability. Where exactly did you get this information because it could be quite useful. I know that in V7.2 or 7.3 they intend to release the ability to create and drop indexes on the fly without locking the table but I have never seen anything about being able to switch off an index and then have it catch up later. Cheers - Jim On May 8, 8:47am, Bill Ennis wrote: > Subject: Re: Deleting Question > Hi, > > If you are running with version 7.x you have the ability to disable > indexes. However, if you disable an index you allow for for the > application of index changes when you turn it back on. This is ok > if you have a period of time when you can delay this processing until. > > Check your SQL manual for instructions for disabling/enabling objects. > > -Bill -- ----------------------------------------------------------------------------- Jim Gordon DHL Airways Inc. jgordon@us.dhl.com ----------------------------------------------------------------------------- My opinions are my own. They may vary with time but they remain mine!