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 subquery in sql?

1092

What are the different type of joins in sql?

1003

What are the different set operators available in sql?

1083

Name some usages of database trigger?

1089

Why we use stored procedure instead of query?

1050

What are the parameter modes supported by pl/sql?

1155

how to drop an existing view in mysql? : Sql dba

1108

What is the difference between microsoft access and sql?

1077

How do I copy a table in sql?

1041

Do foreign keys improve performance?

1068

What is difference between left and right outer join?

1038

What is localdb mssqllocaldb?

1115

How to use sql statements in pl/sql?

1197

Mention what does the hierarchical profiler does?

1145

How do I view a view in sql?

996