Skip to Main Content

SQL & PL/SQL

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!

need example of analytic function single pass

OU_230Sep 27 2017 — edited Sep 27 2017

Could someone please explain what is a single pass vs multipass operation and how analytic function could make SQL single pass to improve performance?

Comments

Mirza_Adeel

Dear ,

Did you resolve it i am facing same issue

Thanks

1 - 1
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Oct 25 2017
Added on Sep 27 2017
11 comments
355 views