How to get actual number of rows (A-Rows) to display in the Rows column of the Explain Plan tab
说明
When DBMS_XPlan is set for the display mode in the Explain Plan tab, it always shows E-Rows as the column header for the Rows column. How can a user get the A-Rows to appear, to see the actual number of rows, instead of the estimated number of rows?
解决办法
Use the GATHER_PLAN_STATISTICS hint in the query to get the actual Row count.
Click here for an article explaining this further.
