From: Becker, Holger (holger.beckersap.com)
Date: Wed Mar 24 2004 - 02:38:17 CST

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

dinamicamartincordova.com wrote

> Is there any document/URL available providing tips to avoid the "Table
> space exhausted..." error in SAPDB 7.4? I have searched thru
> this list and
> google, and can't find a clear answer to this problem. So far
> all I got is
> this:
>
> 1.- There is a problem with the JOIN algorithm used by SAPDB
> 7.4.x - will
> be fixed in a future release of SAPDB 7.4?
>
> 2.- You should have enough indexes as to avoid bad join strategies
>
> 3.- The order of the tables in the FROM clause can affect the
> occurrence
> of this problem.
>
> Is there anything else regarding the CACHE_SIZE parameter or something
> like that?

Hi,

there is no special documentation or URL for this topic.
I think beside the three points you already listed above
the size of your data area is important.
The CACHE_SIZE have no influence to this problem and the
point 3 is only valid for outer joins.

Kind regards,
Holger
SAP Labs Berlin

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

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