The scan operator reads rows into the query plan and makes them available for further processing by the other operators in the query plan. The scan operator is a leaf operator; that is, it never has any child operators. The scan operator can read rows from multiple sources, so the showplan message identifying it is always followed by a from message to identify what kind of scan is being performed. The three from messages are: from cache, from or list, and from table.
