<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; =
charset=3Diso-8859-1">
<META NAME=3D"Generator" CONTENT=3D"MS Exchange Server version =
5.5.2653.12">
<TITLE>Performance Update to RSWWERRE</TITLE>
</HEAD>
<BODY>
<P><FONT SIZE=3D2 FACE=3D"Arial">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 SIZE=3D2 FACE=3D"Arial">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 =3D 'B' and wi_status_started =3D =
'STARTED'). Does anyone have an idea why the index would not be =
used?</FONT></P>
<BR>
<P><FONT SIZE=3D2 FACE=3D"Arial">Thanks,</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">Brad</FONT>
</P>
</BODY>
</HTML>