Filter qualifications (The Filter Run-If on the Basic tab) are not doing searches (since the filter is only firing on a single record) so the != $NULL$ will not do a table scan.
What you are thinking of is the Push Fields If qualification on a Push Fields Action. Fred -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of lee Sent: Wednesday, September 16, 2009 11:52 AM To: [email protected] Subject: Filter qualification using != Hi, I have some filters that use the qualification != $NULL$. In the documentation it says to avoid using != as it will do a full table scan. My question is 'does having != $NULL$ AND Field1 = Organization' make the full table scan smaller? Or Is it better to do a != $NULL$ or LIKE 'CU%" When I try the LIKE qualification, it seems a lot slower (timeout message) compared to the != $NULL$ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:[email protected] ARSlist: "Where the Answers Are"
