I am looking to find the most efficient way of calculating column counts of values. The challenge is making is fairly fluid.
The schema that I have, has (as of today), 69 columns. But this can vary on week to week. I'm looking at getting the column count and then sending an alert to someone if the count is 0...this must also count NULL values.
For example -
So this would give me counts of Name - 6, Age - 4 and Shoe size = 0.
This would then Alert to a user saying shoe size is empty!
I don't need to store the counts anywhere permanently.