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

Can we join two tables without primary key?

0 Answers  


What are the types of sql server?

0 Answers  


What is user defined datatypes and when you should go for them?

0 Answers  


What is the default order of an order by clause?

0 Answers  


How do I install sql server?

0 Answers  






What can be used instead of trigger?

0 Answers   ADITI,


What is SQL server agent?

2 Answers   HCL, SAP Labs,


What is Covering Indexes? Plz explain with example

3 Answers  


Tell me the use of keyword with encryption. Create a store procedure with encryption?

0 Answers  


Why I am getting this error when dropping a database in ms sql server?

0 Answers  


If you're given a raw data table, how would perform etl (extract, transform, load) with sql to obtain the data in a desired format?

0 Answers   Facebook,


While using a cursor, how can you differentiate between a deleted row and a row that has been inserted with null data values?

0 Answers  


Categories