200K *total* records, or 200K records per day/month/quarter/etc? Because
200K records isn't that much on modern hardware. Heck, it wasn't much 20
years ago on "Enterprise" hardware.
And you don't mention the window for loading the data into "the" table, and
then into the reporting table.
Love the forum,
I'm bringing 100k - 200k of AR transactions into a table from several
separate ERP companies.
As I insert the records, does it make sense to run a trigger event to
build or insert data into
a reporting table (to save generating a query to build the reporting
table later.)