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 read uncmmited?

788

How do I run sql server 2014?

694

What is ssrs?

109

Explain the steps needed to create a scheduled job?

674

Write the SQL query to drop, truncate and delete table.

724

how would you store your query in an SSRS report or a Database server?

142

What is the current limitation of the size of SQL Azure DB?

120

What are the disadvantages of using querystrings to send data from one page to another?

766

What is sql server transaction log file?

705

How to filter out duplications in the returning rows in ms sql server?

808

When we should use @@error?

699

what's the difference between delete table and truncate table commands? : Sql server database administration

672

Explain tables in SQL Azure?

114

Can a database be shrunk with users active?

796

How to return the top 5 rows from a select query in ms sql server?

779