cancel
Showing results for 
Search instead for 
Did you mean: 

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

ps_vinay
Explorer
0 Kudos

Systems Recourses needed to run the above maintenance.

ps_vinay
Explorer
0 Kudos

Anybody can help on this?

Accepted Solutions (0)

Answers (1)

Answers (1)

former_member188958
Active Contributor
0 Kudos

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.