Indexes on views
-
Hi, when we create a non clustered index for a table, an index is maintained in the database, but when we create the same on a view , does it get saved anywhere !! , i am also aware that views are not persisted in the DB, so i am a bit confused in this.
-
Hi, when we create a non clustered index for a table, an index is maintained in the database, but when we create the same on a view , does it get saved anywhere !! , i am also aware that views are not persisted in the DB, so i am a bit confused in this.
When selecting from a view, you will normally use the indexes on the base tables. In SQL Server (2000/2005) you can create indexes on a view (views are really virtual tables), but there are several caveats on how they are created. See Books Online for more information.
the last thing I want to see is some pasty-faced geek with skin so pale that it's almost translucent trying to bump parts with a partner - John Simmons / outlaw programmer
Deja View - the feeling that you've seen this post before.