Optimize Teradata UNION ALL with a Single Table Scan Trick
The Idea Behind This Trick for Teradata UNION ALL What if you need to apply a UNION ALL operation to distinct columns within a single table? Typically, the process would involve: The rewrite may permit one base-table scan, but scan count and I/O benefit depend on the optimizer and data. Verify the plan rather than …
