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
    ______________________________________________________________________________________________
  • swagner
    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()