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 is sub query and its properties?
What are the types of table?
What is a view in sql?
Does group by sort data?
If we delete pack Spec what will be the status of pack Body ?
What is difference between inner join and join?
What is used to replicate sessions between instances in coldfusion clusters?
Tell me extended events in sql server 2008?
What are the differences between left join and inner join in sql server?
Why we need to use secondry database file? though, we can do same work using primary database file also.
What are trace flags?
How to how to convert numeric expression data types using the convert() function??
What are the advantages of user-defined functions over stored procedures in sql server?
Explain having clause?
How to count duplicated values in a column in ms sql server?
