Teradata difference between View vs volatile table
What is the difference between a view and a volatile table in Teradata?
|View will not be removed at the end of the session||volatile table is removed at the end of the session|
|View doesn't store any data but retrieves data from underlying table||A volatile table stores the data physically|
|View is public||Volatile table is private to the session|
|Cannot create any stats on views||collect stats can be created|