How to make updateble veiws and Apply Indexing on them???
Database
2
Posts
2
Posters
0
Views
1
Watching
-
Kindly let me know how to make updateble views on a table and how to apply Indexes on them??? i will be very thankful if anyone can give me the exact syntax for whole.. Thanks in Advance..
-
Kindly let me know how to make updateble views on a table and how to apply Indexes on them??? i will be very thankful if anyone can give me the exact syntax for whole.. Thanks in Advance..
Creating an index on a view uses the normal CREATE INDEX syntax. For considerations, you should look at: Creating an Indexed View[^] Also note that this feature is in Enterprise Edition only.
The need to optimize rises from a bad design.My articles[^]