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?

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


Please Help Members By Posting Answers For Below Questions

How to create a local temporary stored procedure?

478


What is the difference between nvl and nvl2?

532


How many null values we can have in a unique key field in sql server?

532


What are the joins in sql server? : sql server database administration

520


Can you tell me some of the common replication dmv's and their use? : sql server replication

519






What does the not null constraint do?

555


How and why use sql server?

520


What are the new features introduced in SQL Server 2000 (or the latest release of SQL Server at the time of your interview)? What changed between the previous version of SQL Server and the current version?

567


How to use "if ... Else if ... Else ..." Statement structures in ms sql server?

514


what are the basic functions for master, msdb, model, tempdb and resource system databases? : sql server database administration

544


What is openxml in sql server?

598


How can you check the version of sql server?

536


How do I start sql server agent automatically?

486


What Is Rdbms?

649


What is triggers in ms sql server?

619