Interested to Buy Any Domain ? << Click Here >> for more details...
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?
- 2 Answers
- 4521 Views
- I also Faced
- E-Mail Answers
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
What is primary key index?
What changes in the front end code is needed if mirroring is implemented for the high availability? : sql server database administration
What are “lost updates”?
How to rebuild the master database?
Difference between report and query parameter.
what are the new features in SSRS?
Explain what are commit and rollback in sql?
How do I find the sql server instance name?
What is sql injection? How to protect against sql injection attack?
How to get nth highest salary from employee table.
Mention the different types of replication in sql server.
What is dbcc updateusage?
What is the sql server 2000 version number?
Is it possible for a stored procedure to call itself or recursive stored procedure?
Please explain go command in sql server?
