Hi! Thank you for the tip.
IDKonto is the primary key -and so it is indexed. I have created the clustered key, this has no effect. The error message occurs. The problem ist that i must have the complete recordset-the list fills my report-control to create a long report. I cant make a serverside view or other dbms-depend "tricks" -- my applicatiom must run also under jet on small installations.... what is the real reason for this error? Can i upgrade hardware (memory,processor e.c.) In Moment my development-system is a athlon 1900+ with 265 M Memory under win2000 pro. by Hagen "Becker, Holger" <[EMAIL PROTECTED]> schrieb im Newsbeitrag news:[EMAIL PROTECTED] > Hagen Schl�mer wrote: --snip-- > > Try it with > > create index refKonten_i1 on refKonten (IDKonto) > create index tblBuchungen_i1 on tblBuchungen (IDMandant, dtmPeriode) > > and > > update stat refKonten > update stat tblBuchungen > update stat refKonten > > This should speed up your statement because of better join transition > and actual optimizer statistics. > > For more information about SAP DB optimizer have a look into > http://www.sapdb.org/7.4/htmhelp/fb/36fe3b34334a7be10000000a114084/frameset. htm > > Best regards, > Holger > SAP Labs Berlin _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
