Archives of the TeradataForum

Message Posted: Wed, 27 Oct 2010 @ 14:11:50 GMT

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

I would recommend adding one more piece.

Between "with data" and "on commit preserve rows", you should add a primary index. Otherwise, it will choose the first column as the PI. Also consider using Multiset if that works for you, as it can improve performance.

Something like this:

     create volatile multiset table testvolatile
     as (select * from database.table
     )
     with data primary index(c1, c2)
     on commit preserve rows
     ;

Steve Woodrow

Check out my latest blog on Maximizing your Teradata System's Performance: developer.teradata.com/blog/woody

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