Re: Creating index does not make any change in query plan. - Mailing list pgsql-general

From Deepa
Subject Re: Creating index does not make any change in query plan.
Date
Msg-id Pine.LNX.4.33.0302171529390.10556-100000@ws1154.midascomm.com
Whole thread Raw
In response to Re: Creating index does not make any change in query plan.  ("Shridhar Daithankar" <shridhar_daithankar@persistent.co.in>)
List pgsql-general
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@postgresql.org
>

--

Bye,
Deepa. K

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


pgsql-general by date:

Previous
From: "Shridhar Daithankar"
Date:
Subject: Re: Creating index does not make any change in query plan.
Next
From: Mohd Ghalib Akhtar
Date:
Subject: HOWTO Migration