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
What is the use of nvl function?
What are the query optimization techniques?
What is set transaction?
What is sql and how does it work?
Is time a data type in sql?
Explain isolation levels. : Transact sql
What are the types of triggers in sql?
Is natural join and inner join same?
what are the differences between require and include, include_once and require_once? : Sql dba
What is a file delimiter?
What operators deal with null?
What is a function in oracle pl sql?
The select into statement is most often used to create backup copies of tables or for archiving records?
What is flag in sql?
Which nosql database is best?