Re: indexing timestamp fields

Поиск
Список
Период
Сортировка
От Bruno Wolff III
Тема Re: indexing timestamp fields
Дата
Msg-id 20031016165629.GA28009@wolff.to
обсуждение исходный текст
Ответ на Re: indexing timestamp fields  (teknokrat <teknokrat@yahoo.com>)
Список pgsql-sql
On Wed, Oct 15, 2003 at 21:25:17 +0100, teknokrat <teknokrat@yahoo.com> wrote:
> 
> I have a lot of queries of the " where timestamp < some date " type and 
> was wondering if an index would improve performance. None of the 
> timestamps are null and they are always populated

Unless that query returns only a small fraction of the table (which would
be unusual for a before some date restriction) or you order by the date,
an index probably won't help.


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

Предыдущее
От: teknokrat
Дата:
Сообщение: indexing timestamp fields
Следующее
От: "Muhyiddin A.M Hayat"
Дата:
Сообщение: Re: Calc