All Forums Database
danR 1 post Joined 01/13
28 Mar 2016
Views - internal processing steps

When using a query (q1) against a view instead of the table(s) which support the view, does TD load the entire view with all data based on the view's tables and filters , before implementing q1 against the view's results.   thank you.

tomnolan 594 posts Joined 01/08
28 Mar 2016

No, the Teradata Database does not materialize the view before querying the view.
Prefix your query with the EXPLAIN keyword in order see all the steps that the Teradata Database will perform when executing your query.

You must sign in to leave a comment.