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

What are different type of Collation Sensitivity?

0 Answers  


Data is not being delivered to subscribers, what can be the possible reasons? : sql server replication

0 Answers  


Write an SQL query to obtain the 2nd highest salary.

0 Answers   Akamai Technologies,


table:employee EID ENAME MID(manager ids) 101 rama null 102 sita 101 103 siva 101 104 ganesh 103 . . . . . . for 103 ID the manager ID is 101(RAMA) and for 104 manager is SIVA if i give employee id (EID) you have to tell the manager for that EID write query? eample:if i give 102 .The query output should be manager for 102 ID that it should print RAMA as output

7 Answers  


What is filestream?

0 Answers  






What is a file group?

0 Answers  


how to get rank of diffrent student in same table based on newly inserted row in sql server2008

4 Answers   ABC,


what command is used to create a table by copying the structure of another table?

7 Answers  


What types of Joins are possible with Sql Server?

0 Answers   NA,


WHY CAN WE CREATE ONLY ONE CLUSTERED INDEX ON A TABLE IN SQL SERVER?

8 Answers  


what is index seek and index scan?

2 Answers  


Let us say the SQL Server crashed and you are rebuilding the databases including the master database what procedure to you follow?

2 Answers  






Categories