Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Indexes on date fields

Indexes on date fields

From: <dipenk_at_my-deja.com>
Date: Mon, 19 Jul 1999 08:42:35 GMT
Message-ID: <7muodq$n1v$1@nnrp1.deja.com>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US