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

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)

Adding a index to a field which is not unique

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

Re: Adding a index to a field which is not unique

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)