Обсуждение: Indexing datetime

Поиск
Список
Период
Сортировка

Indexing datetime

От
Sergei Barbarash
Дата:
Hello,

I have a table for web server logs, which contains a datetime column. Most of
my queries depend on date/time clauses (retrieving periods of time). It works
terribly slow. Can I optimize it somehow? How should I create an index? What
operators should I use in the clauses?

Thanks in advance,

-- Sergei