Search SSWUG.ORG:

DATABASES

Beyond Analytics: MODEL or MATCH_RECOGNIZE This is an off-site link.  Please review our Terms of Service for additional information.




(stewashton) Analytic functions are powerful and efficient, but sometimes they just aren’t enough. When you try analytics and they alone don’t solve the problem, it’s time to think about the MODEL clause – or upgrade to 12c and use MATCH_RECOGNIZE. All three can use partitions and ordering for simpler, more efficient processing.

Read this article...







comments powered by Disqus