Sql Chaining explained

About

All operations on a table return a table.

• A select query returns a table
• A view returns a table
• A common table expression returns a table

The operations on tables can therefore be chained together (ie pipelined)

The Relational algebra expressions dictate how to achieve it by giving:

• what operations to do
• and in what order to do them.