Archives of the TeradataForum
Message Posted: Wed, 26 Mar 2003 @ 17:16:54 GMT
Instead of volatile tables (which don't allow for the collect of stats nor SIs), try using global temporary tables. With Global Temps, you can collect stats and create indexes like a permanent table. In addition, like volatile tables, they will dissappear at the end of your session.
Hope this helps,
|Copyright 2016 - All Rights Reserved|
|Last Modified: 27 Dec 2016|