what is Hash join?how it is different from inner join?what
is the sign used for inner join?(eg: like the (+) sign used
for outer join)?
- 3 Answers
- 16188 Views
- TCS, I also Faced
- E-Mail Answers
Answer Posted / ram
when the joining tables having huge data or selective columns don't have index at that
hash will occured automatically by using optimization
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
How do you remove duplicates without using distinct in sql?
what are rollup and cube in t-sql? : Transact sql
What does the file extension accdb stand for?
Mention what does plv msg allows you to do?
Explain exception handling in pl/sql?
What is composite data type in pl sql?
How does sql profiler work?
What is a temporal table?
Can I learn sql in a week?
What is insert command in sql?
Which nosql database is best?
What is an invalid partition table?
Which query operators in sql is used for pattern matching?
What are the two characteristics of a primary key?
Explain what is a subquery ?
