Re: Deleting Question

Hi, This is undocumented until 7.2 (we're a Beta site for 7.2 and I keep forgetting my manuals are for 7.2). I did try this out on a 7.11 engine and it worked. The syntax for disabling/enabling indexes is as follows: set indexes <index name> disabled/enabled; In additon to indexes this can be done for constraints, triggers. Enabling them can take some time if the table concerned has changed a lot. Bill > > bill, > > > 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. > > i looked briefly in the manual, and couldn't find anything on this. > can you point out where this is? i would like to see this, if there is a > functionality like this, it would make things much easier in many instances, > as in the situation of the original post. > > thanks, > > mickm > -- Bill Ennis Voice: 312-474-7516 SSA Fax: 312-474-7460 500 W. Madison email: ennis@ssax.com