is view in sql server 2000 increase performance
-
Hi all, I have one silly question - is view in sql server 2000 increase performance ?
Krishnraj
indexed View increase perfomance
Vuyiswa Maseko, Few companies that installed computers to reduce the employment of clerks have realized their expectations.... They now need more and more expensive clerks even though they call them "Developers" or "Programmers." C#/VB.NET/SQL7/2000/2005/2008 http://vuyiswamb.007ihost.com http://Ecadre.007ihost.com vuyiswam@its.co.za
-
indexed View increase perfomance
Vuyiswa Maseko, Few companies that installed computers to reduce the employment of clerks have realized their expectations.... They now need more and more expensive clerks even though they call them "Developers" or "Programmers." C#/VB.NET/SQL7/2000/2005/2008 http://vuyiswamb.007ihost.com http://Ecadre.007ihost.com vuyiswam@its.co.za
-
How is this accomplished? If you put indexes, aren't they on the table and not on the view?
Indexes can be added in views and in tables see this http://www.novicksoftware.com/Articles/Indexed-Views-Basics-in-SQL-Server.htm[^] http://articles.techrepublic.com.com/5100-10878_11-6160148.html[^] http://www.microsoft.com/technet/prodtechnol/sql/2005/impprfiv.mspx[^] http://www.sqlteam.com/article/indexed-views-in-sql-server-2000[^] I think i have Supplied enough info Hope it helps
Vuyiswa Maseko, Few companies that installed computers to reduce the employment of clerks have realized their expectations.... They now need more and more expensive clerks even though they call them "Developers" or "Programmers." C#/VB.NET/SQL7/2000/2005/2008 http://vuyiswamb.007ihost.com http://Ecadre.007ihost.com vuyiswam@its.co.za