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
- 4040 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 can sql server instances be hidden? : sql server security
what are the reporting service components in SSRS?
how do you implement one-to-one, one-to-many and many-to-many relationships while designing tables? : Sql server database administration
Explain about builtinadministrator?
How to connect a database with sql express.?
What is implicit cursors?
What is the new security features added in sql server 2014? : sql server security
Explain the cursor lock types?
How to send email from database?
Explain throw statement in sql server 2008?
What is save transaction and save point?
How do I run sql server 2014?
Can you give me some DBCC command options?(Database consistency check) - DBCC CHECKDB - Ensures that tables in the db and the indexes are correctly linked.and DBCC CHECKALLOC - To check that all pages in a db are correctly allocated. DBCC SQLPERF - It gives report on current usage of transaction log in percentage. DBCC CHECKFILEGROUP - Checks all tables file group for any damage.
What is scheduled job and how to create it?
What are rest-style architecture's?
