Friday, November 27, 2009

NUM_ROWS in ALL_INDEXES/USER_INDEXES/DBA_INDEXES has fractional value

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: