RE: Out of result space?

"Noah J SILVA" <[email protected]> Wed, 10 Sep 2003 10:30:53 -0400

Newsgroups	gmane.comp.db.sapdb.general
Message-ID	<[email protected]>

"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