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: [email protected] 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 <http://www.specificintegration.com> 703-376-1249 __20060125_______________________This posting was submitted with HTML in it___ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
