Some of the overall gateway reports have potential to run quite poorly. I had to add a sub-select that had at least two joins in it to make sure we're only getting data from one gateway.

I think for the sort run the reports will run fine, however, it would be interesting to see how they would run after a few years of data being added to the database.

Implementing a star schema will help elevate the need for having sub-selects and multiple join statements.