0 - 8 of 8 tags for volatile tables

I have found that when I create a volatile table with say 200million rows where the primary index is explicitely stated and matches the first column in the table, I use much more spool space than if I just let Teradata defined the primary index.   Should, you define a primary index on a volatile table if the index is only on the first column in the temp t

Hi,
what could be the reasson for data deletion after  "Multiple rows updated" error automatically ?
Thanks
Nagendra

As volatile table definition does not go into DD, how Indexes and stats works on volatile table?

Hi All,
 
Please explain about volatile table ,derived tables and globa temp table ?

Hi All
I want to understand if there will be a difference in performace or on any front between
Any inputs will be of a great help. I am dealing with huge fact tables and many volatile tables to be created in a stored procedure.
 

Is there a way to tweak ODBC/Stata to work with volatile tables in Linux?
Stata (a statistics package) allows SQL statements to be issued directly to ODBC data source. I believe SAS has similar pass-thorugh functionality. There's some description of this here: http://www.stata.com/help.cgi?odbc

Masters,

 I am trying tofind if any one used session-specific volatile or temp tables from Data stage - (TD connector stage) on Teradata ?

I was told by my ETL folks  given the parallel nature of DataStage in that it opens many independent Teradata sessions and hence we cannot use volatile tables ! Did nay one used this ?