Is Not Null and Query Optimization

From: db55 <chfran@xxxxxxxxx>
Date: Thu, 28 Jun 2007 16:22:12 -0000

How does the phrase "Is Not Null" in the where clause effect the
effectiveness of a query?

If it is a determent to the effectiveness of the query, how do you
work around it?

Thanks,

.

Follow-Ups:
- Re: Is Not Null and Query Optimization
  - From: Erland Sommarskog
- Re: Is Not Null and Query Optimization
  - From: Gert-Jan Strik
- Re: Is Not Null and Query Optimization
  - From: Roy Harvey

Prev by Date: Re: DELETE where syntax ... need help :)
Next by Date: Re: Is Not Null and Query Optimization
Previous by thread: DELETE where syntax ... need help :)
Next by thread: Re: Is Not Null and Query Optimization
Index(es):
- Date
- Thread

Relevant Pages

Re: Dynamic SQL generation for the UpdateCommand
... but is the key included in the query? ... W.G. Ryan MVP Windows - Embedded ... Have an opinion on the effectiveness of Microsoft Embedded newsgroups? ...
(microsoft.public.dotnet.framework)
Re: Is Not Null and Query Optimization
... optimizer to choose a query plan that will eliminate all NULL rows. ... If it is a determent to the effectiveness of the query, ...
(comp.databases.ms-sqlserver)
Re: Is Not Null and Query Optimization
... If it is a determent to the effectiveness of the query, ... Roy Harvey ...
(comp.databases.ms-sqlserver)
Re: Dates Printing 1906 instead of 2006
... To test the effectiveness of your fix ... create and run a query with the criteria of Year< 1990. ...
(comp.databases.ms-access)