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
