23 May 2018        Add to Favorites   Report

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

Read great educational content like this and a lot more ! Create my free account now 🎁