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|
Read great educational content like this and a lot more !
Members get free exclusive access to content, new courses, and discounts. Signup for a free account to write a post / comment / upvote posts. Creating an account takes less than 5 seconds and you can start earning badges & points too