Re: Show/Explain Query Plan

From: <kenho_at_my-dejanews.com>
Date: 1998/09/18
Message-ID: <6ttohk$mvb$1@nnrp1.dejanews.com>#1/1

In article <6tsuh2$neq$1_at_imsp009a.netvigator.com>, paulkcng_at_news.netvigator.com (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?
>

It should be always table scan because this query ask to return all the data in table aaa: it does not make sense to use index scan right?

Ken

-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum Received on Fri Sep 18 1998 - 00:00:00 CDT