What is indexed views?
plz explain with example?
Answers were Sorted based on User's Feedback
Answer / mohan
A view with Clustred Index is known as Indexed view.
Is This Answer Correct ? | 4 Yes | 1 No |
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 |
Can we join two tables without primary key?
What are the types of sql server?
What is user defined datatypes and when you should go for them?
What is the default order of an order by clause?
How do I install sql server?
What can be used instead of trigger?
What is SQL server agent?
What is Covering Indexes? Plz explain with example
Tell me the use of keyword with encryption. Create a store procedure with encryption?
Why I am getting this error when dropping a database in ms sql server?
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?
While using a cursor, how can you differentiate between a deleted row and a row that has been inserted with null data values?