There will not be any indexes directly on a join.. what you need to do is look at the primary and secondary forms from that join (and if one or both of them are joins - go further down and look at the primary and secondary forms in that join). Check if the fields that are being searched on, are indexed on these base forms.. and if not index them..
Cheers Joe -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] Behalf Of Melissa Reed Sent: Thursday, April 26, 2007 1:50 PM To: [email protected] Subject: Re: Performance problems with the HPD:HelpDesk_SLA form No, there is not an index table on a join form. We have not added additional ones from the db side. On Apr 26, 11:11 am, Joe D'Souza <[EMAIL PROTECTED]> wrote: > Are these fields indexed? > > Joe > > > > -----Original Message----- > From: Action Request System discussion list(ARSList) > > [mailto:[EMAIL PROTECTED] Behalf Of Melissa Reed > Sent: Thursday, April 26, 2007 11:54 AM > To: [EMAIL PROTECTED] > Subject: Performance problems with the HPD:HelpDesk_SLA form > > We are experiencing problems when users search on the HPD:HelpDesk_SLA > form, either via the form or through the canned SLA performance > reports. If you qualify on Arrival Time or Resolve Time, it can spike > the Oralce CPU usage up to 25% or more (which is a huge amount for our > environment). The query is taking 5-10 minutes to return, longer > during peak times of the day. > > Has anyone else experienced this before? > No virus found in this outgoing message. > Checked by AVG Free Edition. > Version: 7.5.463 / Virus Database: 269.6.1/776 - Release Date: 4/25/2007 > 12:19 PM No virus found in this outgoing message. Checked by AVG Free Edition. Version: 7.5.463 / Virus Database: 269.6.1/776 - Release Date: 4/25/2007 12:19 PM _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
