Forum Stats

  • 3,874,720 Users
  • 2,266,768 Discussions
  • 7,911,958 Comments

Discussions

Optimization for SQL Model Clause in upcoming version

Rajeshwaran, Jeyabal
Rajeshwaran, Jeyabal Member Posts: 87 Bronze Badge
edited May 20, 2016 10:00AM in Database Ideas - Ideas

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.

Rajeshwaran, Jeyabaluser6763535GregVctrieb90d3d0d8-db8b-4960-90d8-64373c630342user5361022sensoftulohmann
10 votes

Active · Last Updated

Comments

  • GregV
    GregV Member Posts: 3,106 Gold Crown

    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
    Rajeshwaran, Jeyabal Member Posts: 87 Bronze Badge

    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.