Re: Filter qualification using !=

2009-09-22 Thread lee
to assess index usage. Jennifer Meyer -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of lee Sent: Wednesday, September 16, 2009 12:52 PM To: arsl...@arslist.org Subject: Filter qualification using != Hi, I have some

Re: Filter qualification using !=

2009-09-17 Thread Guillaume Rheault
similar features. -Guillaume -Original Message- From: Action Request System discussion list(ARSList) on behalf of Meyer, Jennifer L Sent: Wed 09/16/09 1:37 PM To: arslist@ARSLIST.ORG Subject: Re: Filter qualification using != Lee, When you make your qualification statement, try to make

Filter qualification using !=

2009-09-16 Thread lee
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

Re: Filter qualification using !=

2009-09-16 Thread Grooms, Frederick W
- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of lee Sent: Wednesday, September 16, 2009 11:52 AM To: arslist@ARSLIST.ORG Subject: Filter qualification using != Hi, I have some filters that use the qualification != $NULL$. In the documentation

AW: Filter qualification using !=

2009-09-16 Thread Conny Martin
(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

Re: Filter qualification using !=

2009-09-16 Thread Meyer, Jennifer L
Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of lee Sent: Wednesday, September 16, 2009 12:52 PM To: arslist@ARSLIST.ORG Subject: Filter qualification using != Hi, I have some filters that use the qualification != $NULL$. In the documentation it says to avoid using

Re: Filter qualification using !=

2009-09-16 Thread Ben Chernys
, 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