Indexes on date fields

We have a large(ish) table with approx 1m records and quite a few date fields, and these date fields are used regularly to select records. Is it worth putting indexes on these date fields? Would the indexes be used in queries such as

e.g.1 :

select *
from large_table
where date_field1 <= date_variable

e.g. 2 :

select *
from large_table
where date_field2 BETWEEN date_variable1 AND date_variable2

Thanks in advance for any help.

Regards,

Dipen

Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't. Received on Mon Jul 19 1999 - 03:42:35 CDT