title: Should searchable date fields in a database table always be indexed?
body: <p>If I have a field in a table of some date type and I know that I will always be searching it using comparisons like <code>between</code>, <code>&gt;</code> or <code>&lt;</code> and never <code>=</code> could there be a good reason <strong>not</strong> to add an index for it?</p>