Oracle 12c new feature APPROX_COUNT_DISTINCT and FETCH FIRST ROWS
- Posted by Gavin Soorma
- On November 14, 2014
- 0 Comments
If we are dealing with large amounts of data and have to use queries to find count of distinct values of some particular column or group of columns, the new 12.1.0.2 feature APPROX_COUNT_DISTINCT function can be significantly faster than using the traditional COUNT (DISTINCT expr) function with marginal differences in the exact result. The examples […]
Read More