SQL Server is not open-source, and official documents do not include the explanation of properties, so we examined the properties in the real-world query plans output by SQL Server Management Studio (SSMS).
| Property | Category | Reference | Description |
|---|---|---|---|
| Estimated CPU Cost | Cost | Link | Estimated CPU cost. |
| Estimated Execution Mode | Configuration | Link | Row or column read mode. |
| Estimated I/O Cost | Cost | Link | Estimated IO cost. |
| Estimated Number of Executions | Status | Link | Estimated number of executions. |
| Estimated Number of Rows for All Executions | Cardinality | Link | Estimated number of rows returned. |
| Estimated Number of Rows Per Execution | Cardinality | Link | Estimated number of rows returned for each execution. |
| Estimated Number of Rows to be Read | Cardinality | Link | Estimated number of rows read. |
| Estimated Operator Cost | Cost | Link | Estimated cost. |
| Estimated Row Size | Cardinality | Link | Estimated width of returned rows. |
| Estimated Subtree Cost | Cost | Link | Estimated cost of children’s operations. |
| Logical Operation | Configuration | Link | The associated logical operations. |
| NodeId | Configuration | Link | The unique id to distinguish associated operations. |
| Object | Configuration | Link | The objects, tables, indexes, or triggers, that are accessed. |
| Ordered | Status | Link | Whether the data is ordered. |
| OutputList | Configuration | Link | The output column list. |
| Physical Operation | Configuration | Link | The associated physical operations. |
| Predicate | Configuration | Link | The predicate used to filter out data. |
| Storage | Status | Link | The data is row- or column-stored. |