Hi All, I have a custom form with about 250K records and QBE on the Assigned Group field is Leading. Queries on this field are running slow and sometimes timing out. The obvious action I think is to change this to Equal.
What exactly is being changed? AR Server? Database? What would be the impact on users at the time of the change? What is the chance this breaks? ARS 6.3. patch 20 SunOS 5.9 Oracle 9.2 Thanks Mark Mark Brittain Remedy Developer ITILv3 Foundation NaviSite - A Time Warner Cable Company [email protected]<mailto:[email protected]> Office: 315-453-2912 x5335 Mobile: 315-882.5360 ________________________________ This e-mail is the property of NaviSite, Inc. It is intended only for the person or entity to which it is addressed and may contain information that is privileged, confidential, or otherwise protected from disclosure. Distribution or copying of this e-mail, or the information contained herein, to anyone other than the intended recipient is prohibited. _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are"

