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
- 17579 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
How do I view tables in mysql?
What is scope and visibility in PL/SQL?
Can a foreign key be a duplicate?
what is a constraint? Tell me about its various levels. : Sql dba
What is trigger in pl sql with examples?
What are the types of sql commands?
Is pl sql still used?
Can we debug stored procedure?
Write the order of precedence for validation of a column in a table? I. Done using database triggers. Ii. Done using integarity constraints
How can you tell the difference between an index and a view?
What is identity column in sql server?
What are variables in pl sql?
What is sql and explain its components?
how can we encrypt and decrypt a data present in a mysql table using mysql? : Sql dba
Why are indexes and views important to an organization?
