Approximate Query Processing in 12c Release 2

by

Approximate Query Processing appears to be a major feature of Oracle Database 12c Release 2 SQL. In 12cR1 patchset 2 (12.1.0.2), we saw one approximate query function appear – APPROX_COUNT_DISTINCT to use instead of COUNT(DISTINCT). In 12.2 there are several APPROX functions introduced:   APPROX_COUNT_DISTINCT_DETAIL APPROX_COUNT_DISTINCT_AGG TO_APPROX_COUNT_DISTINCT APPROX_MEDIAN APPROX_PERCENTILE APPROX_PERCENTILE_DETAIL APPROX_PERCENTILE_AGG TO_APPROX_PERCENTILE According to Oracle … Read more

Oracle ACED Briefing and Open World

by

My first Oracle HQ visit was for the Oracle ACE Director briefing. Had two good days at the HQ. The briefing started with a super cool session by Thomas Kurian (President, Product Development). He was ready to answer any and all questions we had. Learned a lot about the Oracle cloud products that are on … Read more