Adding an Index to a Query/View

[Darrick]

Hello all,

I am having some trouble with a few of my views. They are timing out, and I would like to optimize them by adding indexes. I am not sure how to actually do this. Any help would be appreciated.

I am using SQL 2000 Standard.

Thanks again,

Darrick

 

[JayKusch]

Open Books Online and look up Indexes Views.

Thanks

J. Kusch

 

[Darrick]

Thanks, but that was the first place I looked. The help really didn't provide much help on what I can do. More or less stated how to put an index on a table and said that it could be applyed to a view as well. However, I haven't had any luck with that method.

Darrick

 

[MDXer]

look in BOL for creating indexed views. Although you can use them and they are extremely efficient there are strict criteria that must be met in order to use them. They view must also be schema bound.

Shoot Me! Shoot Me NOW!!!
- Daffy Duck