Can we disable the indexes on tables as we disable the triggers in sybase12.0? I am using the BCP to insert the data into tables. Existance of triggers and indexes on tables makes SLOW bcp. I had now disabled the triggers and also want to disable the indexes, as i don't want to explictly drop the triggers and then recreate it.

Thanks in advance.

Parvinder Singh

You, to the best of my knowledge, cannot 'disable' an index in ASE. You will have to drop, BCP -in, and recreate the index.