Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 17426 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 difference between inner join and cross join?
What is snowflake sql?
Who is the owner of mysql database?
how can we find the number of rows in a table using mysql? : Sql dba
define sql delete statement ? : Sql dba
What are sql injection vulnerabilities?
What is varchar used for?
what does it mean to have quoted_identifier on? : Sql dba
What is the difference between a subquery and a join?
what is bdb (berkeleydb)? : Sql dba
does sql support programming? : Sql dba
how to rename an existing table in mysql? : Sql dba
Can I call a procedure inside a function?
what are the disadvantages of mysql? : Sql dba
How to find 3rd highest salary of an employee from the employee table in sql?
