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
- 4618 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 are transactions and its controls?
Is profiler the only tool that has the ability to audit and identify ddl events? : sql server security
Explain different types of locks in sql server.
What are the 7 disadvantages to a manual system?
Explain about system database?
What is the current limitation of the size of SQL Azure DB?
there is a trigger defined for insert operations on a table, in an oltp system. The trigger is written to instantiate a com object and pass the newly inserted rows to it for some custom processing. What do you think of this implementation? Can this be implemented better? : Sql server database administration
How to provide default values to stored procedure parameters?
How many categories of data types used by sql server?
How can we migrate from SQL server to SQL Azure?
How to Insert multiple rows with a single insert statement?
How to create a user name in a database?
How is sql used in sql server?
What is apply operator in sql?
Detail about query optimizer?
