MS/SQL - does 1=0 filter push action table scans

[David Chan]

Hi all

I am trying to confirm...

On MS/SQL database, does 1=0 qualification in filter push action cause 
table scan.

I know oracle does... just confirming if SQL 2000 does

thanks... dave

_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the 
Answers Are"