"Becker, Holger" <[EMAIL PROTECTED]>
09/10/2003 10:20 AM
To: "'Noah J SILVA'" <[EMAIL PROTECTED]>, [EMAIL PROTECTED]
cc:
Subject: RE: Out of result space?
Noah J SILVA wrote:
>You really mean no modification?
To the queries/views, yes.
>No update statistic run on the involved tables?
None.
>No additional data in the tables?
Some... not much percentage change though.
>Could you please post the explain plan of the query.
>Please use "explain view" command then the explain shows
>the real table names instead of the view name.
TEST CUI_STAGE1 TABLE SCAN 57
TEST CUI_STAGE1 JOIN VIA KEY COLUMN 92
TEST CUI_STAGE1 TABLE SCAN 60
TEST AE_VIEW_ACTIVE TABLE SCAN 35
INTERNAL TEMPORARY RESULT TABLE SCAN 500
TEST AA_TABLE AA_KEY JOIN VIA KEY COLUMN 4
TEST RESULT IS COPIED , COSTVALUE IS 6632
Best regards,
Holger
SAP Labs Berlin
Thank you,
Noah Silva
IS&T - Senior Programmer Analyst
(215) 419 - 7916
_______________________________________________
sapdb.general mailing list
[EMAIL PROTECTED]
http://listserv.sap.com/mailman/listinfo/sapdb.general
