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
- 16636 Views
- TCS, I also Faced
- E-Mail Answers
Answer Posted / anil kumar jaiswal
Hash Join : When there is no index available on join columns and both table has huge amount of data then oracle optimizer will pick hash join automatically.
we also have use_hash hints in oracle to instruct oracle optimizer to perform hash join on the given Query.
check explain plan for any query to see the join performed on that particular query.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is attribute indicator in pl sql?
What is replication id?
Why is sql important?
What are the two types of periodical indexes?
Does mysql_real_escape_string prevent sql injection?
How many row comparison operators are used while working with a subquery?
what are the disadvantages of mysql? : Sql dba
What is sql and db2?
What is set serveroutput on in pl sql?
What is sql not null constraint?
Can a view be mutating? If yes, then how?
How can you maintain the integrity of your database on instances where deleting an element in a table result in the deletion of the element(s) within another table?
What is a recursive join sql?
How do I restart sql?
How to select random rows from a table?
