Results 1 to 2 of 2
  1. #1
    Join Date
    Dec 2001
    Location
    New Delhi
    Posts
    1

    Unanswered: Disabling Of Triggeres In SYBASE12.0??

    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

  2. #2
    Join Date
    Mar 2001
    Location
    Lexington, KY
    Posts
    606
    You, to the best of my knowledge, cannot 'disable' an index in ASE. You will have to drop, BCP -in, and recreate the index.
    Thanks,

    Matt

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •