Indexes?

Поиск
Список
Период
Сортировка
От Bjørn T Johansen
Тема Indexes?
Дата
Msg-id 41AEB211.2050202@havleik.no
обсуждение исходный текст
Ответы Re: Indexes?
Re: Indexes?
Список pgsql-general
Дерево обсуждения 
I have a table where I need to use "..where curdate between fromDate and toDate".
Is it best to have two indexes, one for FromDate and one for toDate or just one index for
both the fields?


Regards,

BTJ

--
-----------------------------------------------------------------------------------------------
Bjørn T Johansen

btj@havleik.no
-----------------------------------------------------------------------------------------------
Someone wrote:
"I understand that if you play a Windows CD backwards you hear strange Satanic messages"
To which someone replied:
"It's even worse than that; play it forwards and it installs Windows"
-----------------------------------------------------------------------------------------------

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