<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML xmlns=3D"http://www.w3.org/TR/REC-html40" xmlns:o =3D=20
"urn:schemas-microsoft-com:office:office" xmlns:w =3D=20
"urn:schemas-microsoft-com:office:word"><HEAD>
<META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; =
charset=3Diso-8859-1">
<TITLE>Performance Update to RSWWERRE</TITLE>
<META content=3DWord.Document name=3DProgId>
<META content=3D"MSHTML 5.50.4613.1700" name=3DGENERATOR>
<META content=3D"Microsoft Word 9" name=3DOriginator><LINK=20
href=3D"cid:filelist.xml@01C0FEF7.10E7AE50" rel=3DFile-List><!--[if gte =
mso 9]><xml>
<o:OfficeDocumentSettings>
<o:DoNotRelyOnCSS/>
</o:OfficeDocumentSettings>
</xml><![endif]--><!--[if gte mso 9]><xml>
<w:WordDocument>
<w:Zoom>0</w:Zoom>
<w:DocumentKind>DocumentEmail</w:DocumentKind>
<w:EnvelopeVis/>
</w:WordDocument>
</xml><![endif]-->
<STYLE>@font-face {
font-family: Century Gothic;
}
@font-face {
font-family: Tahoma;
}
@page Section1 {size: 8.5in 11.0in; margin: 1.0in 1.25in 1.0in 1.25in; =
mso-header-margin: .5in; mso-footer-margin: .5in; mso-paper-source: 0; =
}
P.MsoNormal {
FONT-SIZE: 12pt; MARGIN: 0in 0in 0pt; FONT-FAMILY: "Times New Roman"; =
mso-style-parent: ""; mso-pagination: widow-orphan; =
mso-fareast-font-family: "Times New Roman"
}
LI.MsoNormal {
FONT-SIZE: 12pt; MARGIN: 0in 0in 0pt; FONT-FAMILY: "Times New Roman"; =
mso-style-parent: ""; mso-pagination: widow-orphan; =
mso-fareast-font-family: "Times New Roman"
}
DIV.MsoNormal {
FONT-SIZE: 12pt; MARGIN: 0in 0in 0pt; FONT-FAMILY: "Times New Roman"; =
mso-style-parent: ""; mso-pagination: widow-orphan; =
mso-fareast-font-family: "Times New Roman"
}
P.MsoAutoSig {
FONT-SIZE: 12pt; MARGIN: 0in 0in 0pt; FONT-FAMILY: "Times New Roman"; =
mso-pagination: widow-orphan; mso-fareast-font-family: "Times New =
Roman"
}
LI.MsoAutoSig {
FONT-SIZE: 12pt; MARGIN: 0in 0in 0pt; FONT-FAMILY: "Times New Roman"; =
mso-pagination: widow-orphan; mso-fareast-font-family: "Times New =
Roman"
}
DIV.MsoAutoSig {
FONT-SIZE: 12pt; MARGIN: 0in 0in 0pt; FONT-FAMILY: "Times New Roman"; =
mso-pagination: widow-orphan; mso-fareast-font-family: "Times New =
Roman"
}
P {
FONT-SIZE: 12pt; MARGIN-LEFT: 0in; MARGIN-RIGHT: 0in; FONT-FAMILY: =
"Times New Roman"; mso-pagination: widow-orphan; =
mso-fareast-font-family: "Times New Roman"; mso-margin-top-alt: auto; =
mso-margin-bottom-alt: auto
}
SPAN.EmailStyle16 {
COLOR: blue; mso-style-type: personal-reply; mso-ansi-font-size: =
10.0pt; mso-ascii-font-family: Arial; mso-hansi-font-family: Arial; =
mso-bidi-font-family: Arial
}
DIV.Section1 {
page: Section1
}
</STYLE>
</HEAD>
<BODY lang=3DEN-US style=3D"tab-interval: .5in">
<DIV><SPAN class=3D057211816-27062001><FONT face=3DArial size=3D2>I did =
look at 168045=20
but it doesn't apply since I cannot do database hints in=20
4.0B.</FONT></SPAN></DIV>
<DIV><SPAN class=3D057211816-27062001><FONT face=3DArial=20
size=3D2>-Brad</FONT></SPAN></DIV>
<BLOCKQUOTE dir=3Dltr style=3D"MARGIN-RIGHT: 0px">
<DIV class=3DOutlookMessageHeader dir=3Dltr align=3Dleft><FONT =
face=3DTahoma=20
size=3D2>-----Original Message-----<BR><B>From:</B> Quenzer, Kenneth =
D=20
[mailto:QuenzeKD@oge.com]<BR><B>Sent:</B> Wednesday, June 27, 2001 =
10:51=20
AM<BR><B>To:</B> SAP-WUG@MITVMA.MIT.EDU<BR><B>Subject:</B> Re: =
Performance=20
Update to RSWWERRE<BR><BR></FONT></DIV>
<DIV class=3DSection1>
<P class=3DMsoNormal><SPAN class=3DEmailStyle16><FONT face=3DArial =
color=3Dblue=20
size=3D2><SPAN=20
style=3D"FONT-SIZE: 10pt; FONT-FAMILY: Arial; mso-bidi-font-size: =
12.0pt">I=20
think that note 168045 is for versions 4.5 and 4.6.<SPAN=20
style=3D"mso-spacerun: yes"> </SPAN>The Select statement was =
changed in=20
the 4.5 and 4.6 versions of RSWWERRE and SAP added a =
“hint” for Oracle to=20
force it to use index C.<SPAN style=3D"mso-spacerun: yes"> =
</SPAN>I don’t=20
think that this hint is needed in the 4.0b version of=20
RSWWERRE.<o:p></o:p></SPAN></FONT></SPAN></P>
<P class=3DMsoNormal><SPAN class=3DEmailStyle16><FONT face=3DArial =
color=3Dblue=20
size=3D2><SPAN=20
style=3D"FONT-SIZE: 10pt; FONT-FAMILY: Arial; mso-bidi-font-size: =
12.0pt"><![if =
!supportEmptyParas]><![endif]> <o:p></o:p></SPAN></FONT></SPAN></P>=
<P class=3DMsoAutoSig><!--[if supportFields]><span =
class=3DEmailStyle16><font=20
size=3D2 color=3Dblue face=3DArial><span =
style=3D'font-size:10.0pt;mso-bidi-font-size:
12.0pt;font-family:Arial'><span =
style=3D'mso-element:field-begin'></span><span=20
style=3D"mso-spacerun: yes"> </span>AUTOTEXTLIST \s "E-mail=20
Signature" <span =
style=3D'mso-element:field-separator'></span></span></font></span><![end=
if]--><FONT=20
face=3D"Century Gothic" color=3Dblue size=3D2><SPAN=20
style=3D"FONT-SIZE: 10pt; COLOR: blue; FONT-FAMILY: 'Century Gothic'; =
mso-bidi-font-size: 12.0pt">Kenny=20
Quenzer</SPAN></FONT><FONT face=3D"Century Gothic" color=3Dblue =
size=3D2><SPAN=20
style=3D"FONT-SIZE: 10pt; COLOR: blue; FONT-FAMILY: 'Century Gothic'; =
mso-bidi-font-size: 12.0pt; mso-color-alt: =
windowtext"><o:p></o:p></SPAN></FONT></P>
<P class=3DMsoNormal><!--[if supportFields]><span =
class=3DEmailStyle16><font=20
size=3D2 color=3Dblue face=3DArial><span =
style=3D'font-size:10.0pt;mso-bidi-font-size:
12.0pt;font-family:Arial'><span =
style=3D'mso-element:field-end'></span></span></font></span><![endif]-->=
<SPAN=20
class=3DEmailStyle16><FONT face=3DArial color=3Dblue size=3D2><SPAN=20
style=3D"FONT-SIZE: 10pt; FONT-FAMILY: Arial; mso-bidi-font-size: =
12.0pt"><![if =
!supportEmptyParas]><![endif]> <o:p></o:p></SPAN></FONT></SPAN></P>=
<P class=3DMsoNormal style=3D"MARGIN-LEFT: 0.5in"><FONT face=3DTahoma =
color=3Dblack=20
size=3D2><SPAN=20
style=3D"FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: =
Tahoma">-----Original=20
Message-----<BR><B><SPAN style=3D"FONT-WEIGHT: bold">From:</SPAN></B> =
Klemba,=20
Michal [mailto:MKlemba@era.pl]<BR><B><SPAN=20
style=3D"FONT-WEIGHT: bold">Sent:</SPAN></B> Wednesday, June 27, 2001 =
10:34=20
AM<BR><B><SPAN style=3D"FONT-WEIGHT: bold">To:</SPAN></B>=20
SAP-WUG@MITVMA.MIT.EDU<BR><B><SPAN=20
style=3D"FONT-WEIGHT: bold">Subject:</SPAN></B> Re: Performance =
Update to=20
RSWWERRE</SPAN></FONT></P>
<P class=3DMsoNormal style=3D"MARGIN-LEFT: 0.5in"><FONT face=3D"Times =
New Roman"=20
size=3D3><SPAN=20
style=3D"FONT-SIZE: 12pt"><![if =
!supportEmptyParas]><![endif]> <o:p></o:p></SPAN></FONT></P>
<P class=3DMsoNormal style=3D"MARGIN-LEFT: 0.5in"><FONT face=3DArial =
color=3Dblue=20
size=3D2><SPAN style=3D"FONT-SIZE: 10pt; COLOR: blue; FONT-FAMILY: =
Arial">Have you=20
implemented a note 168045 as well? It says something about your=20
problem.</SPAN></FONT><FONT color=3Dblack><SPAN=20
style=3D"COLOR: black; mso-color-alt: =
windowtext"><o:p></o:p></SPAN></FONT></P>
<P class=3DMsoNormal style=3D"MARGIN-LEFT: 0.5in"><FONT face=3D"Times =
New Roman"=20
color=3Dblack size=3D3><SPAN=20
style=3D"FONT-SIZE: 12pt; COLOR: black"> </SPAN></FONT><FONT=20
color=3Dblack><SPAN=20
style=3D"COLOR: black; mso-color-alt: =
windowtext"><o:p></o:p></SPAN></FONT></P>
<P class=3DMsoNormal style=3D"MARGIN-LEFT: 0.5in"><FONT face=3DArial =
color=3Dblue=20
size=3D2><SPAN style=3D"FONT-SIZE: 10pt; COLOR: blue; FONT-FAMILY: =
Arial">Michel=20
Klemba</SPAN></FONT><FONT color=3Dblack><SPAN=20
style=3D"COLOR: black; mso-color-alt: =
windowtext"><o:p></o:p></SPAN></FONT></P>
<P class=3DMsoNormal=20
style=3D"MARGIN-BOTTOM: 12pt; MARGIN-LEFT: 1in; mso-margin-top-alt: =
auto"><FONT=20
face=3DTahoma color=3Dblack size=3D2><SPAN=20
style=3D"FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: =
Tahoma">-----Original=20
Message-----<BR><B><SPAN style=3D"FONT-WEIGHT: bold">From:</SPAN></B> =
Schroeter,=20
Brad [mailto:BSchroeter@ti.com]<BR><B><SPAN=20
style=3D"FONT-WEIGHT: bold">Sent:</SPAN></B> 27 czerwca 2001 =
17:14<BR><B><SPAN=20
style=3D"FONT-WEIGHT: bold">To:</SPAN></B> =
SAP-WUG@MITVMA.MIT.EDU<BR><B><SPAN=20
style=3D"FONT-WEIGHT: bold">Subject:</SPAN></B> Performance Update to =
RSWWERRE</SPAN></FONT><FONT face=3DTahoma color=3Dblack =
size=3D2><SPAN=20
style=3D"FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: Tahoma; =
mso-color-alt: windowtext"><o:p></o:p></SPAN></FONT></P>
<P style=3D"MARGIN-LEFT: 1in"><FONT face=3DArial color=3Dblack =
size=3D2><SPAN=20
style=3D"FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: Arial">I am in =
the process=20
of implementing note 136887 (Performance RSWWERRE with Cost Based=20
Optimizer). We're on 4.0B and Oracle 8.0.4.3 (we're supposed to =
be=20
upgrading to 8.1.7 in August/September). In the note it says =
"that you=20
must possibly update the database statistics so that your index works =
correctly (see note 72873)". I've talked to our Basis folks and =
they=20
don't currently do any reorgs on our system due to the size (we're =
the smaller=20
of two systems within our company and we normally run without any =
problems)=20
but that may change in the future.</SPAN></FONT><FONT =
color=3Dblack><SPAN=20
style=3D"COLOR: black; mso-color-alt: =
windowtext"><o:p></o:p></SPAN></FONT></P>
<P style=3D"MARGIN-LEFT: 1in"><FONT face=3DArial color=3Dblack =
size=3D2><SPAN=20
style=3D"FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: Arial">After =
implementing=20
the note I ran a test of RSWWERRE with the SQL trace turned on. =
I can=20
see that instead of using index SWWWIHEAD~C (which it's supposed to =
use), it's=20
doing a full table scan. It's happening on "SELECT * FROM =
SWWWIHEAD INTO=20
TABLE WI_ERRORS WHERE WI_TYPE EQ WI_BATCH AND WI_STAT EQ =
WI_STATUS_STARTED"=20
(wi_batch =3D 'B' and wi_status_started =3D 'STARTED'). Does =
anyone have an=20
idea why the index would not be used?</SPAN></FONT><FONT =
color=3Dblack><SPAN=20
style=3D"COLOR: black; mso-color-alt: =
windowtext"><o:p></o:p></SPAN></FONT></P>
<P class=3DMsoNormal=20
style=3D"MARGIN-LEFT: 1in; mso-margin-top-alt: auto; =
mso-margin-bottom-alt: auto"><FONT=20
face=3D"Times New Roman" color=3Dblack size=3D3><SPAN=20
style=3D"FONT-SIZE: 12pt; COLOR: black"><![if =
!supportEmptyParas]><![endif]> </SPAN></FONT><FONT=20
color=3Dblack><SPAN=20
style=3D"COLOR: black; mso-color-alt: =
windowtext"><o:p></o:p></SPAN></FONT></P>
<P style=3D"MARGIN-LEFT: 1in"><FONT face=3DArial color=3Dblack =
size=3D2><SPAN=20
style=3D"FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: =
Arial">Thanks,</SPAN></FONT><FONT=20
color=3Dblack><SPAN style=3D"COLOR: black"> <BR></SPAN></FONT><FONT =
face=3DArial=20
color=3Dblack size=3D2><SPAN=20
style=3D"FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: =
Arial">Brad</SPAN></FONT><FONT=20
color=3Dblack><SPAN style=3D"COLOR: black"> </SPAN></FONT><FONT =
color=3Dblack><SPAN=20
style=3D"COLOR: black; mso-color-alt: =
windowtext"><o:p></o:p></SPAN></FONT></P></DIV></BLOCKQUOTE></BODY></HTM=
L>