Re: Inner join question

Поиск
Список
Период
Сортировка
От Martijn van Oosterhout
Тема Re: Inner join question
Дата
Msg-id 20040219200405.GA9750@svana.org
обсуждение исходный текст
Ответ на Re: Inner join question  (Randall Skelton <skelton@brutus.uwaterloo.ca>)
Список pgsql-general
On Thu, Feb 19, 2004 at 01:23:34PM -0500, Randall Skelton wrote:
> The main problem was that there wasn't an index on cal_qat_1.  The
> other indexes were fine so I don't know what happened to the first
> one...

How about an index on cal_quat_2.timestamp?

Hope this helps,

--
Martijn van Oosterhout   <kleptog@svana.org>   http://svana.org/kleptog/
> If the Catholic church can survive the printing press, science fiction
> will certainly weather the advent of bookwarez.
>    http://craphound.com/ebooksneitherenorbooks.txt - Cory Doctorow

Вложения

В списке pgsql-general по дате отправления:

Предыдущее
От: Andrew Rawnsley
Дата:
Сообщение: Re: Replication options
Следующее
От: "Joshua D. Drake"
Дата:
Сообщение: Re: Replication options