Re: Show/Explain Query Plan

From: <sybaseuser_at_hotmail.com>
Date: 1998/09/18
Message-ID: <6ttr7b$pu6$1@nnrp1.dejanews.com>#1/1

In article <6ttohk$mvb$1_at_nnrp1.dejanews.com>, kenho_at_my-dejanews.com wrote:
> 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
>

Actually this query ask that no row be returned because 1 is never equal to 2.

-----== 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