In my case, this was inadvertently a good comparison. Most of the "ad-hoc" queries we're doing are AVG, SUM, or similar operations that require scanning the entire table.

I may try to edit this post to compare those operations, as it may be more meaningful.

Thanks for posting the link. TIL.