Here is the question of the day: What is faster way to get total number of records in the table? Answer is COUNT(*), is much faster, below you will find the test that we performed and detailed result of the test.