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?
Answers were Sorted based on User's Feedback
Answer / 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 |
How to insert data with null values?
as a general practice, it is recommended to have dbo be the owner of all database objects however, in your database you find number of tables owned by a user other than dbo, how could you fix this? : Sql server administration
How to loop through the result set with @@fetch_status?
What are clustered and non-clustered index?
What is trigger and different types of Triggers?
What is a heap?
What is the difference between login and a user?
13 Answers CTS, TCS,
Explain about system stored procedure?
How much is a sql server license?
You have to store user responses of ‘yes’ and ‘no’ what kind of data type is best suited for this task?
What is a view in sql?
Insert syudents details in table.Current system date &time insert into joining time.How do insert?( in sysdate only return current system date how do add time?)