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)?
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 does left join work in sql?
What is union?
Can unique keys be null?
How do you modify a trigger?
Can we create table in function?
What is the cause of mutating table error and how can we solve it?
Where are my tempfiles, I don't see them in v$datafile or dba_data_file?
What are literals in sql server?
Is sql considered coding?
Is sql a programming?
Explain autonomous transaction.
What are all ddl commands?
what is an execution plan? When would you use it? How would you view the execution plan? : Sql dba
What does seeding a database mean?
How do I view an execution plan in sql?