SqlDbx Forum

allanb

Guest

Row count incorrect

The number of rows shown on a left side seems to be not accurate.
For example I have a table with 956 rows, but SqlDbx shows on a left side
that table has only 897 rows.

sqldbxhelp

Administrator

Re: Row count incorrect

The row count accuracy depends on a database.
For Oracle and DB2 you have to update statistics.
For Sybase it shows row count estimate from row_count function
For Microsoft SQL Server it should be correct

rony

Member

Re: Row count incorrect

I use Microsoft SQL Server and It  happend to me. Just in one table of the database the row count on the left side dosen't mach.