From the DWHPro archive
Teradata ALTER Table vs. INSERT INTO: Which Method is Efficient?
ALTER TABLE or INSERT INTO a new table? A measured comparison on a large table, and which one actually used fewer resources.
Also worth reading: Teradata SQL Tuning and Query Rewriting
— Roland
Written by Roland Wenzlofsky — 25 years on enterprise data platforms, author of Teradata Query Performance Tuning.
Reply to this email if you think I am wrong. I read every reply.
Not sure whether to migrate or tune what you already have? Thirty minutes, no pitch — and sometimes the answer is don’t migrate. Ask me.
You are receiving this because you subscribed to the DWHPro newsletter.
Unsubscribe
0 comments