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 |
|
dineshrajan_it
Posting Yak Master
217 Posts |
 Posted - 2010-03-23 : 09:34:20
|
| Hi,I have created an index which access the clustered index columnsSo is there any need to create index for views which has result set containing clustered index unless the view has where conditionIam a slow walker but i never walk back |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2010-03-23 : 10:22:29
|
| depends on how view performs. currently how is query involving view performing? do you have some columns inside view which is a constant source of filtering in queries?------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
DBA in the making
Aged Yak Warrior
638 Posts |
Posted - 2010-03-23 : 10:32:31
|
| How many tables does the view contain? When you select from the view, what columns are you filtering on? Do those columns have an index in the underlying table(s)?There are 10 types of people in the world, those that understand binary, and those that don't. |
|
|
|
|
|
|
Using Index for Views