What is a query operator tree in a database

Wh开发者_高级运维at is a query operator tree in a database engine and what does it do?

When a database engine (particularly an SQL-based engine) runs a query, it actually breaks down the query into little steps. Filter a bit here, join a table there, etc. A query operator tree is basically a representation of those steps.