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 does a pl/sql package consist of?

518

Explain the advantages and disadvantages of stored procedure?

649

Is natural join and inner join same?

493

Why we use join in sql?

531

what is csv? : Sql dba

575

What is the usage of when clause in trigger?

566

How many primary keys can a table have?

533

what is a primary key? : Sql dba

554

Why truncate is used in sql?

528

What is a .db file?

541

Lookups are a key component in sql server integration services (ssis). Explain its purpose?

536

how to install mysql? : Sql dba

580

What is sql analyzer?

540

What is a recursive stored procedure?

617

What is linq to sql?

552