APPROXIMATE COUNT (DISTINCT) or COUNT (DISTINCT)

swagner

Can anyone explain the difference in these two functions?  Why use one vs' the other?

ST_Superman

I found this article on APPROX_COUNT_DISTINCT:

https://docs.memsql.com/sql-reference/v6.0/approx_count_distinct/

 

Hope that helps.  It looks to be a performance issue when dealing with very large data sets.

swagner

This appears to be a SQL function.  I'm looking for info on a beastmode function.  

 

I may have mistated the syntax, should be:

APPROXIMATE_COUNT_DISTINCT()