Skip to Content
avatar image
Former Member

What are the System reseorces required for Running reorg and Update stats in Sybase

Systems Recourses needed to run the above maintenance.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Feb 15 at 02:39 PM

    REORG REBUILD makes a new copy of the table before deallocating the old one, so it needs disk space. The general recommendation is to have at least 120% of the current size of the table available as free space.

    Otherwise the main resource needed for both is time.

    Add comment
    10|10000 characters needed characters exceeded