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
- 4045 Views
- I also Faced
- E-Mail Answers
Answer Posted / rama krishna
it depends on search critiria for view
| Is This Answer Correct ? | 0 Yes | 3 No |
Post New Answer View All Answers
What is database dimension? : sql server analysis services, ssas
tell me what is blocking and how would you troubleshoot it? : Sql server database administration
how will add additional conditions in sql?
What is replace and stuff function in sql server?
Which sql server is best?
Explain the benefits of user-defined functions?
Is sql server is free?
What stored by the tempdb ? : sql server database administration
What are click through reports?
Describe in brief sql server monitoring ways.
Thanks to some maintenance being done, the sql server on a failover cluster needs to be brought down. How do you bring the sql server down?
What do you mean by sql server 2005 express management tools?
How can change procedure in sql server?
What are the different types of backups avaialabe in sql server 2005?
How to turn on the mssql api module in php?
