Sorry, I am a tad confused here. Are we talking about a filter qualification? Or a set fields or push fields qualification?
If we're talking a filter qualification, there is never a table scan. In fact there may never be a database call at all (with the possible exception of a db. in the qualification.) Remember that filter qualifications happen after a set of field/value pairs has been submitted for update/create/merge. Fields are modified in memory as filters run and memory is used to evaluate qualifications. If indeed you are talking about push fields or set fields qualifications, then I stand back. Cheers Ben www.softwaretoolhouse.com -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Conny Martin Sent: September 16, 2009 7:34 PM To: arslist@ARSLIST.ORG Subject: AW: Filter qualification using != One can not say in general that having != in a qualification does a full table scan. Here is a little example You have a Form where Field1 has an index. 'Field1' = "foo" would use the index defined on Field1 'Field1' = "foo" and 'Field2' != $NULL$ would use the index defined on Field1 'Field1' = "foo" and 'Field2' = "bar" would use the index defined on Field1 'Field1' != $NULL$ and 'Field2' = "bar" would not(!!) use the index defined on Field1 'Field1' = $NULL$ and 'Field2' = "bar" would not(!!) use the index defined on Field1 'Field1' != "foo" would not(!!) use the index defined on Field1 One can say that using != with an indexed field prevents the database from using that index. If your qualification does not include any other indexed field then this would result in a full table scan. HTH Kind Regards Conny -----Ursprüngliche Nachricht----- Von: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] Im Auftrag von lee Gesendet: Mittwoch, 16. September 2009 18:52 An: arslist@ARSLIST.ORG Betreff: 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:rmisoluti...@verizon.net ARSlist: "Where the Answers Are" ____________________________________________________________________________ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are" _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"
