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

explain normalization concept? : Sql dba

1031

what are the different functions in sorting an array? : Sql dba

1002

how to create a new table in mysql? : Sql dba

970

How to run sql statements through the web interface?

1021

What mean sql?

992

Explain scalar functions in sql?

1045

Why stored procedure is better than query?

924

List the various privileges that a user can grant to another user?

1033

What is program debugging?

1219

how to enter characters as hex numbers? : Sql dba

1025

What is sorting in sql?

928

What are the types of triggers in sql?

1067

Can a table have no primary key?

1038

What is coalesce in sql?

1035

Is sql dba a good career? : SQL DBA

975