What is indexed views?
plz explain with example?

Answers were Sorted based on User's Feedback



What is indexed views? plz explain with example?..

Answer / mohan

A view with Clustred Index is known as Indexed view.

Is This Answer Correct ?    4 Yes 1 No

What is indexed views? plz explain with example?..

Answer / raman

A view with unique Clustred Index is known as Indexed view and its also known as Materialize view

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More SQL Server Interview Questions

Explain what you mean by 3 tier architecture.

0 Answers   TCS,


What is the difference between MVC and Teir Architecher? Plz explain with Layyered Programming example...? Thanks

0 Answers   TCS,


What is the dbcc command and why is it used?

0 Answers  


How can we remove orphan records from a table?

0 Answers  


your sql server is running out of disk space. You notice that there are several large files with ldf extensions what are these files? : Sql server administration

0 Answers  






Can you give an example of Stored Procedure?

4 Answers   Wipro,


hi friends please answer this question ASAP:- how to count the no. of employee in a each department or no. of employee in each location by using emp/dept table

7 Answers   Indecomm,


Define views.

0 Answers  


How to create an index on a view?

0 Answers  


After the SQL installation what are the jobs will you configure?

1 Answers   G7 CR Technologies, IBM, Satyam,


Explain the categories of stored procedure?

0 Answers  


what is database replicaion? : Sql server database administration

0 Answers  


Categories