Differences from abstract plan derived tables

SQL derived tables should not be confused with abstract plan derived tables. An abstract plan derived table is a derived table used in query processing, the optimization and execution of queries. An abstract plan derived table differs from a SQL derived table in that it exists as part of an abstract plan and is invisible to the end user.