Results 1 to 2 of 2
  1. #1
    Join Date
    Jul 2007
    Posts
    3

    Question Unanswered: reorg failed in the middle - does that cause performance issue

    I am a new sybase developer. We had a reorg failed in the middle and noticing performance issue on the sybase 12.5 ase.

    Do you know if reorg failure might cause this?

    thanks,
    Dean.

  2. #2
    Join Date
    Aug 2002
    Location
    Madrid, Spain
    Posts
    97
    A failed reorg does not corrupt the table, and the indexes remain all valid. So, no problem from that side. Probably, your problem is related to statistics, which weren't correctly updated since reorg failed. So, if you cannot afford re-running reorg but can run update statistics, try this.

    Regards,
    Mariano Corral

Posting Permissions

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