<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=us-ascii">
<META content="MSHTML 6.00.6000.16414" name=GENERATOR></HEAD>
<BODY>
<DIV><SPAN class=576102916-15052007><FONT face=Arial
size=2>Hello,</FONT></SPAN></DIV>
<DIV><SPAN class=576102916-15052007><FONT face=Arial
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=576102916-15052007><FONT face=Arial size=2>We are trying to
identify very poor performance levels of the RT Application 3.6.3 on REHL/Apache
with Oracle. In doing so, we had our DBAs take a look at the Oracle box
and the identified some very expensive queries that were taking nearly 10
seconds to return, such as:</FONT></SPAN></DIV>
<DIV><SPAN class=576102916-15052007><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: 'Arial','sans-serif'"><BR>SELECT *
FROM <BR></SPAN><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: 'Arial','sans-serif'"> ( SELECT
limitquery.*, rownum limitrownum FROM <BR></SPAN><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: 'Arial','sans-serif'">
( SELECT main.* FROM <BR></SPAN><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: 'Arial','sans-serif'">
( SELECT DISTINCT main.id <BR></SPAN><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: 'Arial','sans-serif'">
FROM CustomFields main <BR></SPAN><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: 'Arial','sans-serif'">
JOIN ObjectCustomFields ObjectCustomFields_1 ON (
ObjectCustomFields_1.CustomField = main.id ) <BR></SPAN><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: 'Arial','sans-serif'">
WHERE (main.Name = 'Customer') <BR></SPAN><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: 'Arial','sans-serif'">
AND (ObjectCustomFields_1.ObjectId = '0') <BR></SPAN><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: 'Arial','sans-serif'">
AND (main.LookupType = 'RT::Queue-RT::Ticket') )
distinctquery, <BR></SPAN><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: 'Arial','sans-serif'">
CustomFields main <BR></SPAN><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: 'Arial','sans-serif'">
WHERE (main.id = distinctquery.id) <BR></SPAN><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: 'Arial','sans-serif'">
ORDER BY main.SortOrder ASC, main.id ASC ) <BR></SPAN><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: 'Arial','sans-serif'"> limitquery
WHERE rownum <= 1 ) <BR></SPAN><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: 'Arial','sans-serif'"> WHERE
limitrownum >= 1<?xml:namespace prefix = o ns =
"urn:schemas-microsoft-com:office:office" /><o:p></o:p></SPAN></DIV></SPAN><SPAN
class=576102916-15052007>
<DIV><BR><FONT face=Arial size=2>Their concern is mainly around the joins being
inequality joins, as even indexes won't help with these types of queries.
Has anyone seen this same behavior and/or has anyone done anything to modify the
system to generate better join clauses in the queries? </FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV></SPAN><SPAN class=576102916-15052007><FONT face=Arial size=2>Also I must
note, we only have 450 tickets in the system at this time...this was in just
over a week with less than half of the users active, so we expect the number to
grow significantly as we onboard additional users.</FONT></SPAN></DIV>
<DIV><FONT face=Arial size=2><SPAN
class=576102916-15052007></SPAN></FONT> </DIV>
<DIV><FONT face=Arial size=2><SPAN
class=576102916-15052007>Thanks,</SPAN></FONT></DIV>
<DIV align=left>
<DIV align=left><FONT face=Arial size=2></FONT> </DIV><SPAN
style="FONT-SIZE: 9pt; COLOR: #587076; FONT-FAMILY: 'Microsoft Sans Serif'">
<P class=MsoNormal
style="MARGIN: 0in 0in 0pt; mso-pagination: none; tab-stops: 3.0in; mso-layout-grid-align: none; mso-margin-top-alt: auto; mso-margin-bottom-alt: auto"
align=left><FONT size=2><SPAN><STRONG><FONT size=3><FONT size=2>Jeff
Stark</FONT></FONT></STRONG></SPAN></FONT></SPAN></P></DIV>
<DIV> </DIV></BODY></HTML>