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?
Answer Posted / 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 |
Post New Answer View All Answers
How to create a local temporary stored procedure?
What is the difference between nvl and nvl2?
How many null values we can have in a unique key field in sql server?
What are the joins in sql server? : sql server database administration
Can you tell me some of the common replication dmv's and their use? : sql server replication
What does the not null constraint do?
How and why use sql server?
What are the new features introduced in SQL Server 2000 (or the latest release of SQL Server at the time of your interview)? What changed between the previous version of SQL Server and the current version?
How to use "if ... Else if ... Else ..." Statement structures in ms sql server?
what are the basic functions for master, msdb, model, tempdb and resource system databases? : sql server database administration
What is openxml in sql server?
How can you check the version of sql server?
How do I start sql server agent automatically?
What Is Rdbms?
What is triggers in ms sql server?