Thanks for all the info. In this scenario the user (at a minimum) is supposed to apply filters on year, month, and customer (an orders history table with 100 million plus rows, but provided they filter should not be more than 40k rows ever returned).
Why can't that control be applied at the application level?