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
- 17656 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 the difference between inner join and outer join?
What are local and global variables and their differences?
Mention what plvcmt and plvrb does in pl/sql?
Are there any features that are decommissioned in 11g that are not present in 11g?
How insert into statements in sql?
What are dml commands?
What are the possible values for the boolean data field?
How many databases can sql express handle?
How long will it take to learn pl sql?
what is oltp (online transaction processing)? : Sql dba
Differentiate between pl/sql and sql?
Name three sql operations that perform a sort.
How do you optimize a stored procedure in sql?
How do I run a sql trace?
What is the meaning of disabling a trigger?
