Database Reference
In-Depth Information
Figure 3-10.
Cardinality Estimation and Memory Grants: Execution plans
Even though the execution plans look very similar, the cardinality estimations and memory grants are different.
Another difference is that the
Sort
operator icon in the second query has an exclamation mark. If you look at the
operator properties, you will see a warning, as shown in Figure
3-11
. It shows that this operation spilled to
tempdb
.
