I tried in both SSMS and MVC View. The view is taking time in both. I tried executing the view after creating the index but still, it took 2:37 to execute. I have chosen...

No, I am not using sp_whoisactive. The execution plan is to display all the rows in asp.net MVC view page.

I executed the view now and it took 2mins 5sec to execute 354 rows. Last time it had taken little more (I think 2:24). Phonebook table has 66 rows, TagBase...