Skip to Content
0

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

Mar 02, 2017 at 10:11 AM

37

avatar image
Former Member

Systems Recourses needed to run the above maintenance.

10 |10000 characters needed characters left characters exceeded
Former Member

Anybody can help on this?

0
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Bret Halford
Feb 15 at 02:39 PM
0

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.

Share
10 |10000 characters needed characters left characters exceeded