Re: index / sequential scan problem - Mailing list pgsql-performance

From Shridhar Daithankar
Subject Re: index / sequential scan problem
Date
Msg-id 3F16D36A.20463.3954D1@localhost
Whole thread Raw
In response to Re: index / sequential scan problem  (Fabian Kreitner <fabian.kreitner@ainea-ag.de>)
List pgsql-performance
On 17 Jul 2003 at 13:12, Fabian Kreitner wrote:

> At 11:17 17.07.2003, Shridhar Daithankar wrote:
> >How about
> >
> >  where   ma_id  = 2001::integer
> >and     ma_pid = 1097::integer
> >
> >in above query?
>
> I dont really understand in what way this will help the planner but ill try.

That is typecasting. It helps planner understand query in more correct fashion.

Bye
 Shridhar

--
QOTD:    "I may not be able to walk, but I drive from the sitting posistion."


pgsql-performance by date:

Previous
From: Fabian Kreitner
Date:
Subject: Re: index / sequential scan problem
Next
From: Paul Thomas
Date:
Subject: Re: index / sequential scan problem