Hi, my answer was too quick. It works once and now i�ve got the same error. But i don�t what to update the optimizer statistic ervery time before i start an query. There must be somewhere else an mistake. I tried to execute the same query on our Server (Pentium 3 with 500 Mhz and 256 MD RAM) and got again the "Space for result table exhausted"-error. Where is my failure??
Greeting, Andreas Robert Krueger schrieb am 05.06.03 10:34:38: > > > try updating the optimizer statistics (see manual). it many of those cases > that helps. > > On Thursday 05 June 2003 10:22, Andreas Grund wrote: > > Hi, > > > > i�ve got a little Problem with SAP DB 7.4.3.10. I write a SQL-Statement, > > with should return 52 records. It�s a large SQL-Statement with an left > > outer join in it and some where-condition. As i tipped it�s in the > > SQL-Studio i�ve got the error, that the space for the result table is > > exhausted. I work under WinNt 4.0 SP 6 with 128 MB Ram and 8 GB Harddisc > > and a virtual RAM no the Harddisc form 300 MB on C:. On this Device are > > 1.45 GB free memory. Where is my mistake? > > > > Thanks and greetings, > > Andreas > > ___________________________________________________________________________ > >_ Jetzt bei WEB.DE FreeMail anmelden = 1qm Regenwald schuetzen! Helfen Sie > > mit! Nutzen Sie den Serien-Testsieger. http://user.web.de/Regenwald > > > > _______________________________________________ > > sapdb.general mailing list > > [EMAIL PROTECTED] > > http://listserv.sap.com/mailman/listinfo/sapdb.general > ______________________________________________________________________________ UNICEF bittet um Spenden fur die Kinder im Irak! Hier online an UNICEF spenden: https://spenden.web.de/unicef/special/?mc=021101 _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
