|
Confidential From: Michael Lewis <mlewis@xxxxxxxxxxx>
Where's the query? Are you able to run explain analyze so we can see estimates vs actual counts? What version are you using? Can you share explain analyze before and after the window function? Based on the hint here. We looked at the query and found most of the culprits were with a param that forced all accessible records – it should not have been there in most cases. We have removed that
for most users and its fine ! |
