Forum Discussion
kevinconseil
May 29, 2020Copper Contributor
How to increase SQL query performance of a view?
Hi everyone, I am new to Microsoft community, so please let me know if this post is not in the right forum and if so which one would be the right one. issue: - Update & query (using Power BI...
Simple_Balayeur
Jun 05, 2020Brass Contributor
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
Mohit_Bhilare
Apr 18, 2024Copper Contributor
Simple_Balayeur How can we add indexes on view, if view definition contains left or right or outer apply join?