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