Performance Update to RSWWERRE

[Quenzer, Kenneth D]

Hi Brad,
 
We are currently on 4.0b and RSWWERRE is using index C as it should.  When
you run the SQL trace and do an Explain SQL on the select statement does it
say that performance is bad because no index is used?  If so, then I would
recommend having the basis folks update the database statistics.
 
Kenny Quenzer
 
-----Original Message-----
From: Schroeter, Brad [mailto:BSchroeter at ti.com]
Sent: Wednesday, June 27, 2001 10:14 AM
To: SAP-WUG at MITVMA.MIT.EDU
Subject: Performance Update to RSWWERRE
 
I am in the process of implementing note 136887 (Performance RSWWERRE with
Cost Based Optimizer).  We're on 4.0B and Oracle 8.0.4.3 (we're supposed to
be upgrading to 8.1.7 in August/September).  In the note it says "that you
must possibly update the database statistics so that your index works
correctly (see note 72873)".  I've talked to our Basis folks and they don't
currently do any reorgs on our system due to the size (we're the smaller of
two systems within our company and we normally run without any problems) but
that may change in the future.
After implementing the note I ran a test of RSWWERRE with the SQL trace
turned on.  I can see that instead of using index SWWWIHEAD~C (which it's
supposed to use), it's doing a full table scan.  It's happening on "SELECT *
FROM SWWWIHEAD INTO TABLE WI_ERRORS WHERE WI_TYPE EQ WI_BATCH AND WI_STAT EQ
WI_STATUS_STARTED" (wi_batch = 'B' and wi_status_started = 'STARTED').  Does
anyone have an idea why the index would not be used?
 
Thanks,
Brad
 
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://mailman.mit.edu/pipermail/sap-wug/attachments/20010627/020e44d9/attachment.htm