Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

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.

Added on May 20 2016

#active, #database-ideas, #database-ideas-ideas

2 comments

682 views