This view returns around 380K rows and it takes around 2 minutes. There is not really a baseline to tell ,if it is slow or fast , but the goal is the improve its performance. The only tweak I did is the replacement of ' distinct' with 'Group bys'. Any pointers towards tweaking this query will be helpful.
By Amey 1 asked Nov 13, 2017 at 04:29 PM