Sql Chaining explained
Table of Contents
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.