Forum Discussion
How to increase SQL query performance of a view?
Hi Kevin
I1)f you want to use a view (slow) then you can put indexes on the view on the columns which are used in the join clauses.
3)You can also create indexes on the columns of the tables of the view, that are used in the join clauses
4)Stores procedures are usually faster then views because they are compiled
article:
https://www.techrepublic.com/article/see-performance-gains-by-using-indexed-views-in-sql-server/
Hope this helps,
Bye
Simple_Balayeur Thanks for the info 🙂
1- By putting indexes on a view, do you mean creating a indexed view ? If yes then this is currently not an option as my view does not fit many requirements from the indexed view
3- I already have indexes on the base tables of the view
4- I m gonna investigate the stored procedure thanks 🙂