[samstokes]

This certainly helps, but if your indices are several GB in size, even an index scan is a nontrivial expense.