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!
Could someone please explain what is a single pass vs multipass operation and how analytic function could make SQL single pass to improve performance?