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
- 17800 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
Is pl sql different from sql?
What is a pdo connection?
Which is faster union or join?
What is a sql instance vs database?
What is vector point function?
What are string functions in sql?
what is an extent ? : Sql dba
Can we rollback after truncate?
What sql does db2 use?
how to return query output in html format? : Sql dba
What is the main reason behind using an index?
What are the types of dbms?
Show how functions and procedures are called in a pl/sql block.
Does sap use sql?
Does sql require a server?
