Archives of the TeradataForum

Message Posted: Wed, 26 Mar 2003 @ 17:16:54 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

Srini,

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,

Clay

	<Prev	Next>		<<First	<Prev	Next>	Last>>