Question: what is the difference between count and count_rows tests?
Answer: The COUNT_ROWS test counts all values, including nulls, in a column. The performance of the COUNT_ROWS test is faster than that of the COUNT test because the COUNT test checks each data value to see if it is null before incrementing the count.