 |
 |
Archives of the TeradataForum
Message Posted: Sat, 14 May 2011 @ 22:51:57 GMT
| Subj: | | Re: Use case statement to select the desired table |
| |
| From: | | frank.c.martinez |
Anomy.Anom wrote:
| | You can UNION ALL all the tables in one view and then SELECT from the view with your filter. | |
Which means that the optimizer may load all of the tables into spool and then do any selection on it. Much better to put it all in one table,
maybe use PPI on the regions (perhaps!) and pretend it's a real Teradata table (sorry, sarcasm alert).
iv
| |
