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 > > _______________________________________________________________________________ > UNSUBSCRIBE or access ARSlist Archives atwww.arslist.orgARSlist:"Where the > Answers Are"- Hide quoted text - > > - Show quoted text - _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
