Neohapsis is currently accepting applications for employment. For more information, please visit our website www.neohapsis.com or email firstname.lastname@example.org
RE: SAPDB reorganization
From: Zabach, Elke (elke.zabachsap.com)
Date: Mon Apr 19 2004 - 01:02:10 CDT
Yoshizawa, Takahiro wrote:
> There is a question about the Database reorganization after a
> large amount of data is deleted with SAPDB.
> When data is deleted, does SAPDB execute the reorganization
> of the database at once?
> In that case, does SAPDB never have an extra page?
> Does SAPDB release the page at a constant cycle?
> In that case, will SAPDB have an extra page?
> Or, is it another completely logic?
> I doubt the size of table (BKPF) of SAPDB has not changed
> before and after the execution of the data archive.
> Please advise. Thanks!
> Takahiro Yoshizawa
this is the list for MaxDB-open-source-users without R/3-usage.
Please ask the local support, usually.
But as it is just a short answer, I will give it here:
there is no reorganization needed for MaxDB. When rows are deleted,
pages are freed on the fly, not within an extra reorganization step.
SAP Labs Berlin
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb