What is indexed views?
plz explain with example?

Answer Posted / 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       View All Answers


Please Help Members By Posting Answers For Below Questions

Will the writetext statement activate a trigger?

744


What are the advantages of policy management?

749


What do you mean by cardinality?

652


What does truncate do?

698


what is memory-optimized nonclustered indexes

734






Where the sql logs gets stored?

716


How can you find out how many rows returned in a cursor?

754


What is the default order of an order by clause?

778


What's new in sql management studio for sql server? : sql server management studio

766


How do I clean up sql server transaction log?

744


What is an index. What are the types?

750


How to get a list of columns using the "sp_help" stored procedure in ms sql server?

752


What is de-normalization in sql database administration? Give examples?

713


What is transaction server distributed transaction?

725


What are dml (data manipulation language) statements in ms sql server?

736