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
10644
February 08, 2018 11:01AM
1745
February 08, 2018 01:11PM
1190
February 09, 2018 03:52AM
944
February 09, 2018 10:59AM
Re: Count Table rows using Stored Procedure
986
February 12, 2018 09:13AM
971
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.