I need help to improve the performance of this view
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.