Results 1 to 2 of 2
  1. #1
    Join Date
    Sep 2003
    Location
    Wellington
    Posts
    4

    Unanswered: DOL and index growth

    We have a table with Row level locking with 60Million rows.
    The indexes grow about 300MB a day. It is a table with a lot of inserts and deletes, But no updates.
    When we do a reorg rebuild on the table we gain about 10GB in space back.
    However this is a 24/7 system. How do we get around rebuilding indexes in a 24/7 system.
    Sybase version is 11.9.2 (Application people to busy implementing new functionality to upgrade!)

  2. #2
    Join Date
    Feb 2002
    Location
    Willy is on vacation
    Posts
    1,208
    Unfortunately no other way, unless you decide to upgrade to ASE 12.5.0.3

    This release implements aggressive House Kepping with new GC activties.

    Cheers,

    Willy

Posting Permissions

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