Teradata difference between View vs volatile table
What is the difference between a view and a volatile table in Teradata?
| View | Volatile table |
| 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 |
dan-irving
posted on 23 May 18Enjoy great content like this and a lot more !
Signup for a free account to write a post / comment / upvote posts. Its simple and takes less than 5 seconds
Post Comment