23 May 18 · dan-irving · #teradata ·   Bookmark   ×

Teradata difference between View vs volatile table

What is the difference between a view and a volatile table in Teradata?

ViewVolatile table
View will not be removed at the end of the sessionvolatile table is removed at the end of the session
View doesn't store any data but retrieves data from underlying tableA volatile table stores the data physically
View is publicVolatile table is private to the session
Cannot create any stats on viewscollect stats can be created


posted on 23 May 18

Enjoy 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