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

How does postgresql compare to oracle/db2/ms sql server/informix?

1093

What does truncate mean in sql?

1082

Explain the working of primary key?

1152

How to know the last executed procedure?

1156

Explain about various levels of constraint.

1000

What is the main difference between sql and pl/sql?

1148

What is a schema? How is it useful in sql servers?

1174

Where do we use pl sql?

1051

what is view? : Sql dba

1029

What does where 1/2 mean in sql?

1141

Does user triggers have entry for trigger with compilation errors?

1090

Are ddl triggers fired for ddl statements within a pl/sql code executed using the dbms.sql package?

1140

Why do we need databases?

1086

Can a select statement fire a trigger?

1205

How do you change a value in sql?

1064