Question: What are Different Methods to Know the Row Count of Table? The answer to this question is very simple and many.
After a lot of testing, I figured out that the newly introduced function is not always efficient. A newly-introduced function APPROX_COUNT_DISTINCT.
Let us understand how we can quickly identify the workload type of read-heavy or write-heavy by counters. Comprehensive Database Performance Health Check