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
- 4504 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
How to create an index on an existing table in ms sql server?
What are the properties of the transaction?
What is optimistic concurrency?
Explain important index characteristics?
What is indexed view?
is there a column to which a default can't be bound? : Sql server database administration
What is the difference between system objects and user objects?
What happens when transaction log is full?
How to run queries with sql server management studio express?
What are diverse clauses that form a part of sql?
How to copy the tables, schema and views from one sql server to another?
Why do we need different type of parameter?
What is difference between getdate and sysdatetime in sql server 2008?
State a few properties of relational databases?
List the ways in which dynamic sql can be executed?
