Neohapsis is currently accepting applications for employment. For more information, please visit our website www.neohapsis.com or email email@example.com
RE: General advise to deal with "-904 table space exhausted...."
From: Becker, Holger (holger.beckersap.com)
Date: Wed Mar 24 2004 - 02:38:17 CST
> 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
> 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
> of this problem.
> Is there anything else regarding the CACHE_SIZE parameter or something
> like that?
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.
SAP Labs Berlin
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb