Re: Show/Explain Query Plan

Hello,

        I believe the optimizer always considers a table scan and will usually take that path if the table doesn't have many rows in it.

Robert
abpitg_at_ibm.net

Ng K C Paul wrote:
>
> 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