Seq Scan

Поиск
Список
Период
Сортировка
От Linh Luong
Тема Seq Scan
Дата
Msg-id 3B127B88.D5A783A7@computalog.com
обсуждение исходный текст
Список pgsql-general
Hi,

I am trying to execute this query I wrote and it is not returning at a
reasonable time to the browser.  I took the query and ran EXPLAIN on it
and it displayed that every JOIN I do it is doing a Seq Scan on it.  I
have indexes on that table but it doesn't seem to use it.

Is there a way I can ensure that postgres will use my indexes?

Thanks again


Linh

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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: set datestyle
Следующее
От: Tom Lane
Дата:
Сообщение: Re: set datestyle