<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1">
<TITLE>Performance Update to RSWWERRE</TITLE>
<META content="MSHTML 5.00.2314.1000" name=GENERATOR></HEAD>
<BODY>
<DIV><FONT color=#0000ff face=Arial size=2><SPAN class=570002815-27062001>Have
you implemented a note 168045 as well? It says something about your
problem.</SPAN></FONT></DIV>
<DIV><FONT color=#0000ff face=Arial size=2><SPAN
class=570002815-27062001></SPAN></FONT> </DIV>
<DIV><FONT color=#0000ff face=Arial size=2><SPAN class=570002815-27062001>Michel
Klemba</SPAN></FONT></DIV>
<BLOCKQUOTE style="MARGIN-RIGHT: 0px">
<DIV align=left class=OutlookMessageHeader dir=ltr><FONT face=Tahoma
size=2>-----Original Message-----<BR><B>From:</B> Schroeter, Brad
[mailto:BSchroeter@ti.com]<BR><B>Sent:</B> 27 czerwca 2001 17:14<BR><B>To:</B>
SAP-WUG@MITVMA.MIT.EDU<BR><B>Subject:</B> Performance Update to
RSWWERRE<BR><BR></DIV></FONT>
<P><FONT face=Arial size=2>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.</FONT></P>
<P><FONT face=Arial size=2>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?</FONT></P><BR>
<P><FONT face=Arial size=2>Thanks,</FONT> <BR><FONT face=Arial
size=2>Brad</FONT> </P></BLOCKQUOTE></BODY></HTML>