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

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.