Hi, try to update the statistic information for the three tables with "update stat <tablename>". If this doesn't help please send me the explain output and the optimizer statistics from the tables.
Kind regards, Holger SAP Labs Berlin > -----Original Message----- > From: Ralf Koellner [mailto:[EMAIL PROTECTED]] > Sent: Freitag, 22. M�rz 2002 03:35 > To: sapdb.general > Subject: strange performance problems with a simple join > > > Hi again, > > somewhere in my database model I have the three tables user, > user_installation and installation. I need to join the tables like > > SELECT USER.NAME, INSTALLATION.WEIGHT > FROM USER, INSTALLATION, USER_INSTALLATION > WHERE USER_INSTALLATION.USER_ID = USER.USER_ID > AND USER_INSTALLATION.INSTALLATION_ID = INSTALLATION.INSTALLATION_ID > > Primary keys are: > USER.USER_ID > INSTALLATION.INSTALLATION_ID > USER_INSTALLATION.USER_ID + USER_INSTALLATION.INSTALLATION_ID > > Strange is that there are only 26 records in the USER_INSTALLATION > table, but the statement needs about 2 minutes and reports the Native > error: -904 POS(1) Space for result tables exhausted. > > A "EXPLAIN <the select statement from above>" reports that > the DB needs > to do a table scan on the installation and user table and a join via > multiple key columns. > > Does anyone have a clue what I am doing wrong respectively > what could be > wrong with the DB? > > Thank you very much, > > Ralf Koellner > > _______________________________________________ > 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
