Procedure taking long time to exeucte
This SP taking long time to get results. Basically in the main select query I am using one view and in that view i am using one scalar function. That causing the problem and I can't avoid that function call in the view. Is there any way I can increase the performance of this SP.