About
The original Optimizer estimates are shown in the E-Rows (E stands for Estimate) column while the actual statistics of an actual plan gathered during execution are shown in the A-Rows column.
- A Rows: Output Rows from VSQL_PLAN_STATISTICS
- A time
- Buffers
Articles Related
Management
View
- VSQL_PLAN_STATISTICS_ALL: SQL execution runtime statistics for cached SQL cursors
Configuration
If you want to capture the execution statistics:
- STATISTICS_LEVEL must be set to ALL.
- The GATHER_PLAN_STATISTICS hint must be used