APPROXIMATE COUNT (DISTINCT) or COUNT (DISTINCT)

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

Comments

  • 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.


    ______________________________________________________________________________________________
    “There is a superhero in all of us, we just need the courage to put on the cape.” -Superman
    ______________________________________________________________________________________________
  • 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()