Views - internal processing steps

Database
N/A

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.

1 REPLY
Teradata Employee

Re: Views - internal processing steps

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.