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 transaction control language (tcl)?

1148

Does sql backup shrink transaction log?

989

How many clustered indexes can be created on a table?

1085

how do you tune the slow running queries in oracle db , explain the methodology

2847

What is pivot in sql?

920

What is query execution plan in sql?

1195

What is database sql?

1060

What is normalization sql?

1070

what is 'mysqlshow'? : Sql dba

1039

What are conditional predicates?

1066

What is trigger in sql? Explain

1003

What are functions in sql?

968

Can we perform dml on view?

1055

What is a common use of group by in sql?

1057

What does partition by mean in sql?

972