Re: Count Table rows using Stored Procedure
Posted by:
A. Aquiles
Date: February 12, 2018 09:13AM
Not interested in controversy, but I'm not sure about the statistical bit.
I've got a table that has not been touched in 2 years (that's why I have migrated it in the first place). So it's not transactional or, if you prefer, does not suffer changes.
So I compare both tables (in 2 separate servers) using SELECT COUNT(*). Both give exactly and precisely same no. of rows (which indicates COUNT(*) does the right thing, counting rows, how could it be statistical?).
However, if you use <information_schema>, tables in both servers show very different -and very inaccurate!- no. of rows. They don't match at all.
I tried to read the link you included but couldn't find the intended reference.
Subject
Views
Written By
Posted
10293
February 08, 2018 11:01AM
1696
February 08, 2018 01:11PM
1133
February 09, 2018 03:52AM
911
February 09, 2018 10:59AM
Re: Count Table rows using Stored Procedure
947
February 12, 2018 09:13AM
942
February 12, 2018 11:08AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.