From: Zabach, Elke (elke.zabachsap.com)
Date: Mon Apr 19 2004 - 01:02:10 CDT

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]

Yoshizawa, Takahiro wrote:
>
> Hello,
>
> 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
>

Dear SAP-customer,
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.

Elke
SAP Labs Berlin

--
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]