Forum Stats

  • 3,757,254 Users
  • 2,251,216 Discussions
  • 7,869,779 Comments

Discussions

What is the best way to approximate unique users?

User_C2R0L
User_C2R0L Posts: 3 Employee
edited Aug 5, 2021 1:05AM in General Database Discussions

I want to use approximation to speed up my calculation of distinct users.

Is there a way I can use Apache DataSketches directly on the Oracle DB?

Currently, using jdbc, I have to load an entire column into memory before I can create a sketch to find how many of the values are unique.

It would also be helpful if I could get suggestions for other solutions for approximating distinct users from Oracle DB.

Thanks

Best Answers

Answers