Show/Explain Query Plan

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