23 May 18 · dan-irving ·       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


posted on 23 May 18

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