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 _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
