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
- 4542 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
Do you know what is bit data type and whats the information that can be stored inside a bit column?
What is command parameter in ssrs?
Define left outer join in sql server joins?
Tell me what is the significance of null value and why should we avoid permitting null values?
What is primary key index?
Explain the various types of concurrency problem?
Data is not being delivered to subscribers, what can be the possible reasons? : sql server replication
What is the order in which the sql query is executed?
What's new in sql management studio for sql server? : sql server management studio
How does index makes search faster?
What is user-defined scalar function?
Why is sql server log file full?
How to get a list of columns using the "sp_help" stored procedure in ms sql server?
Tell me about normalization in DBMS.
What are system databases into sql server (2005/2008)?
