- 17.9K All Categories
- 3.4K Industry Applications
- 3.4K Intelligent Advisor
- 73 Insurance
- 537.3K On-Premises Infrastructure
- 138.6K Analytics Software
- 38.6K Application Development Software
- 6K Cloud Platform
- 109.6K Database Software
- 17.6K Enterprise Manager
- 8.8K Hardware
- 71.2K Infrastructure Software
- 105.3K Integration
- 41.6K Security Software
Optimization for SQL Model Clause in upcoming version
Read and utilized MODEL clause a lot, basically for inter row calculation where lead and lag can't be used and it looks really cool, thanks for this feature in Oracle.
Recently while bench marking them on large data sets found , SQL Model clause uses more temp and very slow (many orders of magnitude) when compared to Analytic.
please go through these threads, you can understand them.
Any plans for optimizing the SQL Model clause for the upcoming versions ? would really helps.