Disabling Of Triggeres In SYBASE12.0?? [Archive]

parvinder_s_99

01-08-02, 02:30

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

MattR

03-18-02, 20:33

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