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
How to generate create function script on an existing function?
What are the advantages of using stored procedures in sql server?
How to create a login account in ms sql server to access the database engine using "create login" statements?
What are group functions in query statements in ms sql server?
Differentiate between mongodb vs. Sql server?
What is the difference between sql server 2000 object owner and sql server 2005 schema? : sql server database administration
What is xdr?
as a general practice, it is recommended to have dbo be the owner of all database objects however, in your database you find number of tables owned by a user other than dbo, how could you fix this? : Sql server administration
Explain few examples of RDBMS?
Can sql servers linked to other servers like oracle?
how to create a scrollable cursor with the scroll option? : Sql server database administration
How do I find the size of a sql server database?
What are page splits?
You want to implement the one-to-one relationship while designing tables. How would you do it?
how to create “alternate row colour”?