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 is a file delimiter?

1094

Does sql full backup truncate logs?

1014

Can we call stored procedure in function?

957

Explain the rollback statement?

1009

What is a unique key?

1054

How do I partition in sql?

963

Is it possible to read/write files to-and-from PL/SQL?

1102

Enlist the characteristics of pl/sql?

1801

What is cursor in pl sql with examples?

1033

What is sql profiler in oracle?

1092

Is sql a microsoft product?

951

Does pl/sql support create command?

1105

Explain what is a field in a database and record in a database?

1097

what is the difference between a having clause and a where clause? : Sql dba

1087

What is count * in sql?

997