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 spatial and temporal data?

1010

When cursors are useful?

1109

What is user-defined multi-statement table-valued function?

1068

How to deploy the Report?

138

How to make conditional sum in ssrs?

177

What keyword you will use to get schema appended to the result set of a ‘for xml’ query?

1024

What is 2nf example?

1000

How much does sql server 2016 cost?

1076

How to create sub reports?

245

Data is not being delivered to subscribers, what can be the possible reasons? : sql server replication

1048

hi, how to link a text file and a .rpt file in my tables of sql server and to retrieve those records for further use. reply me as soon as possible.

2071

How to access the deleted record of an event?

1040

Can a table be created inside a trigger?

973

What is the Control Flow in SSIS

1095

Define left outer join in sql server joins?

969