Skip to Main Content

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.

Comments

GregV May 20 2016

Hi,

It seems to me the MODEL cause hasn't evolved since its introduction in 10g. If you look at the manuals since then, you'll see no new features or enhancements brought up to now. It's a shame, I also like the power of this clause. Optimization would be great indeed, as the MODEL clause tends to become quite slow when dealing with a huge dataset.

Rajeshwaran Jeyabal May 20 2016

Hi,

It seems to me the MODEL cause hasn't evolved since its introduction in 10g. If you look at the manuals since then, you'll see no new features or enhancements brought up to now. It's a shame, I also like the power of this clause. Optimization would be great indeed, as the MODEL clause tends to become quite slow when dealing with a huge dataset.

Agreed with you Greg. but lets add our ideas here. I hope Oracle SQL Developer Advocate team will look into these.

1 - 2

Post Details

Added on May 20 2016
2 comments
718 views