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

Isn't there a way to select records for a given date range from this table without regard to the ref# 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 tax?