Hi, yes, I agree with Robert Krueger that updating the optimizer statistics may help, because the optimizer will use a better strategy, what will lead to smaller intermediate results.
If this dosn't help you should have a look to the strategy used to execute your command. You can see it by writing the keyword EXPLAIN before your query and executing this query. Maybe you can add some further indexes to your tables to avoid table scans and big intermediate results. BTW, a short explanation of the error you get: -907 is an errorno used in the database kernel. It is used if a CONNECT is sent to the kernel and there is not enough temporary space left to create those temporary things needed for every session. If your database is not nearly full, then we have some trouble with temporary data produced by sessions already at work. The TEMP SPACE isn't defined by a database parameter. It depends directly on the size of your devspaces. A larger disk space can be defined using the database administration tool. Hope this helps regards, Marco ---------------------------------------------- Marco PASKAMP SAP DB, SAP Labs Berlin > -----Original Message----- > From: Robert Krueger [mailto:[EMAIL PROTECTED] > Sent: Donnerstag, 5. Juni 2003 10:35 > To: Andreas Grund; [EMAIL PROTECTED] > Subject: Re: Space for result table exhausted error > > > > 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 > _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
