Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...


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



If there exist a index on the table, and we then make a view on that table (include the indexed co..

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

If there exist a index on the table, and we then make a view on that table (include the indexed co..

Answer / rama krishna

it depends on search critiria for view

Is This Answer Correct ?    0 Yes 3 No

Post New Answer

More SQL Server Interview Questions

Is candidate a key?

0 Answers  


Explain how long are locks retained within the repeatable_read and serializable isolation levels, during a read operation with row-level locking?

0 Answers  


How many files can a database contain in sql server?how many types of data files exists in sql server? How many of those files can exist for a single database?

0 Answers  


What action plan is preferred if sql server is not responding?

0 Answers  


What are the acid properties?

0 Answers  






What is 3nf normalization form?

0 Answers  


What is query processing?

0 Answers  


you have developed an application which uses many stored procedures and triggers to update various tables users ocassionally get locking problems which tool is best suited to help you diagnose the problem? : Sql server administration

0 Answers  


Define left outer join in sql server joins?

0 Answers  


What do you understand by the analysis services in sql server?

0 Answers  


Is it safe to delete log files?

0 Answers  


What are the character string functions supported by sql server 2005?

0 Answers  






Categories