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 |
|
admin001
Posting Yak Master
166 Posts |
 Posted - 2008-04-03 : 11:03:06
|
| Hi,I am having a non-indexed view on SQL 2000 database which calls one table which has some non-clustered indexes and one clustered index .We are having some performance issues at present due to some addition in new functionalities . I want to know whether it would be appropriate to have indexes on view also since the table it calls already has some of them or is it a best practice to have indexes on views rather than a table if the view is being used frequently. Not sure how to test this to validate which change would be appropriate. Any advise would be really helpful .Many thanks. |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-04-03 : 22:21:25
|
| Check execution plan of the view first, ensure it uses proper index when pull data from base table. |
 |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-04-03 : 23:10:05
|
| Index views have limitation:It needs to be schema-bounded and others .Check BOL |
|
|
|
|
|
|
Indexed View - Need advise