Re: [PERFORM] Bulk loading/merging

[Worky Workerson]

Another little question ... would using any sort of TEMP table help out, i.e. loading the unaggregated data into a TEMP table, aggregating the data via a SELECT INTO another TEMP table, and then finally INSERT ... SELECT into the master, aggregated, triggered table?  It seems like this might be a win if A) the TEMP tables fit into memory, and B) the load data aggregates well.  Worst case ( i.e. all unique data in the load) seems like it might take much longer, however, since I'm creating 2 new TEMP tables ....