Common Table Expressions (CTE)

Database
Enthusiast

Re: Common Table Expressions (CTE)

Also, could you please share any link or pointer where I can find complete details about the CTE

Teradata Employee

Re: Common Table Expressions (CTE)

No compilation necessary in either case. It is just part of the SQL SELECT statement and is all parsed/optimized together. The second form in not like a virtual table, it is very specific to defining a recursive select statement.

In the SQL Data Manipulation manual under the SELECT statement there is a subsection on the WITH modifier that tells all about it.

Re: Common Table Expressions (CTE)

Newbie. ;)

Re: Common Table Expressions (CTE)

GTT should be allowed to be created with DATA the same way VT are.