Ray, Work with your folks and change the query to STATUS <= 4. Either way that query will help with performance even if you add index to status field.
Dave -------------------------- [EMAIL PROTECTED] (Wireless) ----- Original Message ----- From: Action Request System discussion list(ARSList) <arslist@ARSLIST.ORG> To: arslist@ARSLIST.ORG <arslist@ARSLIST.ORG> Sent: Sun May 27 18:23:53 2007 Subject: Re: Adding a index to a field which is not unique ** Sorry. Should have mentioned that. The response times during certain times are slow for the users. These users are looking for open tickets (STATUS < 5) and a character field called DOMAIN (DOMAIN = “PERFORMANCE”). Thanks Ray From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Frank Caruso Sent: Sunday, May 27, 2007 6:17 PM To: arslist@ARSLIST.ORG Subject: Re: Adding a index to a field which is not unique ** 1. Why. 2. What exactly is the other field? What type of data does it hold? On 5/27/07, Ray M <[EMAIL PROTECTED] > wrote: Hi: lot of my users run regular queries using two fields in HPD::HelpDesk form (one that was created by me and the other one STATUS). This value for both the fields are not unique. I am thinking of adding indexing on the fields. Anyone comments or suggestions before I make this change? Ray _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are" -- Frank Caruso Specific Integration, Inc. Senior Remedy Engineer, ITIL Foundation Certified www.specificintegration.com 703-376-1249 __20060125_______________________This posting was submitted with HTML in it___ __20060125_______________________This posting was submitted with HTML in it___