David, there have been lots of discussions about this in the past. the outcome was that even Oracle does not perform a table scan on this. For more info please search the archives. If you would like to find out how MS SQL2000 does this you could use the SQL Profiler tool which should be installed on the server or at least at the DBA's workstation.
MORE IMPORTANT: there is no real need for the use of 1=0. If you want a push fields action to always create requests, you should leave the field under "Push Field If" empty, and select If No Requests Match: "Create New Request". This would always create a new request. -- Michiel On 10/28/06, David Chan <[EMAIL PROTECTED]> wrote:
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"
_______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
