In general, temporary tables are way faster for writing than normal tables as
they don't generate WAL records.
On Tuesday, February 12, 2013 11:45:22 AM Little, Douglas wrote:
Hi,
Design question.
Does it make a difference for a function to repeatedly update a temp table
verses the perman
Hi,
Design question.
Does it make a difference for a function to repeatedly update a temp table
verses the permanent table?
We are working in a data warehousing environment.
We have daily etl that's used to update our dimension table which has approx.
500k rows.
A dimension row holds all of the
