Creating index on views?

[Zargo]

Hi all,

I have an huge view. Is it possible to create indexes on views. Is it better to create tables in stead of views and index those tables, maybe tables are faster then views?

TIA,

Zargo

 

[mrdenny]

Tables will almost always be faster than views (if the views have joins in them).

Look up "indexed views" in BOL. You can index a view, however there are specific rules about indexing the view.

I'd probably recommend setting up indexes on the underlying tables.

If the view is queried a lot and is only needed for read access loading the data into a table nightly and reading off of that table will put much less load on the SQL Server.

Denny
MCSA (2003) / MCDBA (SQL 2000) / MCTS (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com