June 18, 2014 at 9:16 pm
Hi,
I have a view which select some few columns from multiple tables with where clause and have 5 unions of different category of data.
For the best performance i need to change this to physical table or any other options which can increase my performance.
Let me know any pointers/url to expedite more on this.
-Ganga
June 19, 2014 at 12:04 am
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
June 23, 2014 at 5:56 am
Indexed views could help.
If you create the table, which is just a matter of creating the table using the CREATE TABLE T-SQL syntax, you will then have to load and maintain the data in that table. Be sure that's the right way to go. Also, before you go down this road, be sure you've tuned the query performance as much as you can. Maybe there are other tuning opportunities in the query.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply