Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
mmalaka
Starting Member
33 Posts |
 Posted - 2008-07-15 : 12:00:40
|
| Experts,What would be better regarding performance: using views or using tables? i have a big table and I am looking into creating Views/Tables from that table...Is there any recommendation about improving the performance of the views or tables in general?Thanks |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-07-15 : 12:05:00
|
| queries fired against view will in turn fetch data from base tables. So i dont think using views will improve the query performance much. |
 |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-07-15 : 22:01:47
|
| You can advantages of Indexed views on top of indexes inside table. |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-07-15 : 23:32:02
|
| With certain restrictions. |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-07-15 : 23:57:06
|
quote:
Originally posted by sodeep
You can advantages of Indexed views on top of indexes inside table.
For making view to be indexed, it should satisfy a lot of conditions.http://www.sqlteam.com/article/indexed-views-in-sql-server-2000 |
|
|
|
sachinsamuel
Constraint Violating Yak Guru
383 Posts |
Posted - 2008-07-17 : 04:54:10
|
| Using views can give flexibility interms of code management, as you can re-use them. But as far as performance is concerned, view will be slower as compared to directly fetching records from the table.You can try this by creating a small POC.Don't sit back because of failure. It will come back to check if you still available. -- Binu |
|
|
|
|
|
|
View Vs Table