Re: Creating index does not make any change in query plan.

On Mon, 17 Feb 2003, Shridhar Daithankar wrote:

Sorry its not exactly 4 bytes, its greate than 4 bytes.

> On 17 Feb 2003 at 15:14, Deepa wrote:
>
> > On Mon, 17 Feb 2003, Shridhar Daithankar wrote:
> >
> > > when you say id=2, it uses default int type which is smallint, AFAIK. So
> > > smallint != bigint and hence planner does not consider using index.
> >
> > But even when a number that has a value of 4 bytes is set in the where
> > condition, the planner is not uses indexed scan. In this case how come
> > this will take the number as small int. Is their any other reason for
> > that.
>
> 4 bytes != bigint.
>
> Bye
> Shridhar
>
> --
> wok, n.: Something to thwow at a wabbit.
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to majordomo(at)postgresql(dot)org
>

--

Bye,
Deepa. K

--
Engineer,
Network Management System,
Midas Communication Technologies private Ltd,
Chennai.