Yes, they are all in the same file group.

And When I say "hot", because the very large datafile holds so much of the data, many more reads are targeted against...

No, sorry. That is a typo, should be PRD_summary.

Thanks dad, I'll be home by 10.

No, the data is too big at this point. I could send you the result set clearly showing results outside of the date restrection

PRD_UNIT could potentially have more than one row per prdkey. It would be rare though.

I'm beginning to think that the OR clauses are allowing the query to go outside...