Differences from abstract plan derived tables

Do not confuse SQL derived tables with abstract plan derived tables. An abstract plan derived table is 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.