Re: index / sequential scan problem

From: "Shridhar Daithankar" <shridhar_daithankar(at)persistent(dot)co(dot)in>
To: pgsql-performance(at)postgresql(dot)org
Subject: Re: index / sequential scan problem
Date: 2003-07-17 11:18:42
Message-ID: 3F16D36A.20463.3954D1@localhost
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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."

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Paul Thomas 2003-07-17 12:34:45 Re: index / sequential scan problem
Previous Message Fabian Kreitner 2003-07-17 11:13:06 Re: index / sequential scan problem