I have a ledger detail table that lets say has 500,000 records. I have one index on the date field and reference field.

Isn't there a way to select records for a given date range from this table without regard to the reference, quickly?

I am finding that unless the search expression matches the index expression exactly this could be a slow process. Isn't it possible some way to "jump into" the table for a search routine at a particular date and then "jump out" of the search routine after a specific date since date is the first field of the index tag?