ksexton
SSCrazy
Points: 2790
More actions
July 24, 2002 at 12:13 pm
#58290
How does the indexing of views work?
Steve Jones - SSC Editor
SSC Guru
Points: 736504
July 24, 2002 at 1:54 pm
#433317
Generally they are not indexed. The underlying table indexes are used. If you do choose to index a view, then it builds this index and takes overhead to update it when any of the underlying tables cause a change.
Steve Jones
sjones@sqlservercentral.com
http://www.sqlservercentral.com/columnists/sjones
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply