when the joining tables having huge data or selective columns don't h

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)?

Question Posted / ram

Answer Posted / ram

when the joining tables having huge data or selective columns don't have index at that
hash will occured automatically by using optimization

Is This Answer Correct ?

0 Yes

0 No

Please Help Members By Posting Answers For Below Questions

What are two statement types in sql?

1029

What is crud stand for?

930

What is left join in postgresql?

993

How can we store rows in PL/SQL using array?

1158

What are aggregate and scalar functions?

973

How to avoid using cursors?

1036

What does subquery mean in sql?

988

Can 2 queries be executed simultaneously in a distributed database system?

1079

How to connect a sql*plus session to an oracle server?

1079

how to check server status with 'mysqladmin'? : Sql dba

1010

What are the types of variable use in pl sql?

1008

What are the various levels of constraints?

1058

What are the limitations of sql express?

984

What is the difference between rename and alias?

1267

What is the difference between instead of trigger and after trigger?

947