Skip to Main Content

Database Software

Announcement

For appeals, questions and feedback, please email oracle-forums_moderators_us@oracle.com

Optimization for SQL Model Clause in upcoming version

Rajeshwaran JeyabalMay 20 2016 — edited May 20 2016

Team,

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.

https://asktom.oracle.com/pls/apex/f?p=100:11:0::::P11_QUESTION_ID:9526697800346367340#9526706000346044533

https://asktom.oracle.com/pls/apex/f?p=100:11:0::::P11_QUESTION_ID:9528975800346991566#9529117900346111898

Any plans for optimizing the SQL Model clause for the upcoming versions ? would really helps.

Thanks,

Rajesh.

Comments
Post Details
Added on May 20 2016
2 comments
581 views