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 |
Post New Answer View All Answers
What language is sql server written in?
What are the types of database schema? : sql server analysis services, ssas
What is difference between join and natural join?
How can a database be repaired?
How to create database with physical files specified in ms sql server?
Define outer join?
What is the default port for SQL Server over a firewall?
how many no of arguments can be passed in procedures and functions
What is 2nf example?
explain the storage models of olap? : Sql server database administration
List all types of constraints in sql server?
Define Business Edition in SQL Azure?
Write the SQL query to drop, truncate and delete table.
What is the difference between function and stored procedure in sql server?
Explain “row_number()” in sql server with an example?