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 is the difference between resultset and resultsetmetadata?

934

Delete duplicate rows without using rowid.

1526

what are candidate key, alternate key and composite key? : Sql server database administration

893

What is snapshot parameter in ssrs?

150

What is the difference between varchar and varchar(max) datatypes?

1047

Does a server store data?

902

What is normalization? Explain its different types?

1071

What is a transactions?

1025

What are logical database components? : SQL Server Architecture

1011

How to change a login name in ms sql server?

1059

Can we add a cpu to sql server?

987

What are data regions?

133

How to write a query with a left outer join in ms sql server?

960

Can multiple columns be used in sql group by clause in ms sql server?

1025

Explain a differential backup?

994