If there exist a index on the table, and we then make a
view on that table (include the indexed column from base
table) than why do we require indexing on view?Doesnt it
create an overhead?
Answers were Sorted based on User's Feedback
Answer / sql2000
Lets start on what a view is, view is a name given to a
select statement. The select statement is executed when the
view name is called.
When you create index on the view the select statement is
materialized into a table and we have the contents of the
select statement as a table. This makes it faster at times
to run select statements on rather than the actual tables.
Hence it makes sense to create indexes on views.
Let me know if anyone has a better point of view on
this. :)
Is This Answer Correct ? | 0 Yes | 0 No |
What is your recommendation for a query running very slow? : sql server database administration
What samples and sample databases are provided by microsoft?
What is exclusive locks?
What is the usage of the sign function?
What happens if the update subquery returns multiple rows in ms sql server?
Explain contrast amongst grouped and non-bunched records?
how do we find every fifth record in a table
What is inline variable assignment?
What is the command used to check locks in microsoft sql server?
Does group by or order by come first?
What are various aggregate functions that are available?
How do we upgrade from SQL Server 6.5 to 7.0 and 7.0 to 2000?