Get rid of your $NULL$ qualifications - they will always force a table scan. Perhaps if you could add something to the qual that would narrow down the number of rows - preferably on an indexed field?
Rick On Thu, Jun 19, 2008 at 11:57 AM, Kathy Morris <[EMAIL PROTECTED]> wrote: > ** Hello, > > I am running an escalation on the Help Desk form that runs at a specific > time with a RUN IF qualification of ( 'ztmpSub' = $NULL$ ) AND ( 'Assignee' > != $NULL$ ) > > Then push some X into the group field if (Assignee = Joe Smith) or > (Assignee=Jane Doe) or about 7 other names. > > I want to be able to modify selected old records at a specific time. When > the escalation runs, this hoses the server. Within the qualification, is > there a better way to narrow down the search results? > > ------------------------------ > Get the Moviefone > Toolbar<http://toolbar.aol.com/moviefone/download.html?ncid=aolcmp00050000000011>. > Showtimes, theaters, movie news, & more! > __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" > html___ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
