join indexes are called as materialized view.these are created for frequent

What is a materialized view?

Question Posted / priya

Answer Posted / priya

join indexes are called as materialized view.these are created for frequently joining columns to improve the join query performance.

Is This Answer Correct ?

0 Yes

0 No

Please Help Members By Posting Answers For Below Questions

What do you understand by check constraint in sql server?

884

What is normalization according to you and explain its different levels?

894

How do you create an execution plan?

882

What is the difference between primary key and unique constraints?

898

What are page splits?

954

What do you mean by normalisation?

961

Can you explain various data region available in ssrs with their use?

915

What is the difference between Clustered and Non-Clustered Index?

1008

Recommend an approach to ensuring that all changes in the remote databases synchronize with the SQL Azure database?

128

How to configure and test odbc dsn settings?

1096

Explain having clause and where clause?

988

What is trace flag in sql server?

975

Explain different types of self contained sub query?

948

How to change server name in sql server?

1097

What is sql server schema compare? How we can compare two database schemas?

958