Doing things right or do right things? How to find row count of every table in database efficiently.

One Data Engineer had to replicate data from one well-known database vendor to a less-known database vendor.He used select count(*) to validate that tables row counts were equal on the source and target.It worked so slowly, that he got…