Re: Show/Explain Query Plan

From: Dan Guzman <nospamplease_guzmanda_at_mindspring.com>
Date: 1998/09/18
Message-ID: <6ttgs5$f45$1@camel18.mindspring.com>#1/1

I believe the table scan plan is correct since there are no joins or row filtering criteria. Unfortunately, the plan does not show that the evaluation of the literal apparently occurs first so the subordinate table scan never takes place when the literal condition is false.

Hope this helps.

Ng K C Paul wrote in message <6tsuh2$neq$1_at_imsp009a.netvigator.com>...
>Sometimes, I wonder if I should trust the plan returned from the query
>optimizer. For example,
>
>create table aaa (a int)
>
>select * from aaa
>where 1=2
>
>Some plans show table scan for the above query. Is it normal?
Received on Fri Sep 18 1998 - 00:00:00 CDT