Which is faster: BETWEEN or 2 WHERE statements?

Поиск
Список
Период
Сортировка
От Chuck Roberts
Тема Which is faster: BETWEEN or 2 WHERE statements?
Дата
Msg-id 11ce83be23d519810420717592ceab78@mail.gmail.com
обсуждение исходный текст
Ответы Re: Which is faster: BETWEEN or 2 WHERE statements?  (Thom Brown <thom@linux.com>)
Список pgsql-novice

Psql 8.4

 

Which will help the query run faster on my version of Psql;

 

1) WHERE (mydate >= '2015-01-01') AND (mydate<='2015-01-31')

 

2) WHERE (mydate BETWEEN '2015-01-01' AND '2015-01-31')

 

I'm just curious.  We have 500,000+ records to go through on this one table, and query involves 2 tables. The date field 'mydate' is not indexed.

 

Thank you!

 

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

Предыдущее
От: Lacey Powers
Дата:
Сообщение: Re: How to create tables and copy records in blocks?
Следующее
От: Thom Brown
Дата:
Сообщение: Re: Which is faster: BETWEEN or 2 WHERE statements?