Re: index / sequential scan problem

Поиск
Список
Период
Сортировка
От Shridhar Daithankar
Тема Re: index / sequential scan problem
Дата
Msg-id 3F16D36A.20463.3954D1@localhost
обсуждение исходный текст
Ответ на Re: index / sequential scan problem  (Fabian Kreitner <fabian.kreitner@ainea-ag.de>)
Список 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 по дате отправления:

Предыдущее
От: Fabian Kreitner
Дата:
Сообщение: Re: index / sequential scan problem
Следующее
От: Paul Thomas
Дата:
Сообщение: Re: index / sequential scan problem