Description:
When I used the below query to select NUM_ROWS but, I got the fractional value.
SQL>SELECT NUM_ROWS FROM DBA_INDEXES WHERE TABLE_NAME=’TABLE_NAME’;
Returned Value is 1228868.88217523.
I have used Analyze table estimate statistics with 10 percent, Sometimes Analyze table estimate statistics will not round the value for NUM_ROWS.
Solution I tried:
To avoid this I used ANALYZE TABLE COMPUTE STATISTICS.
No comments:
Post a Comment