Answer Posted / ankush
A hash join is a join optimization method where two tables
are joined based on a hashing algorithm.
Hashing refers to the conversion of a column's primary key
value to a database page number on which the row will be
stored. Retrieval operations that specify the key column
value use the same hashing algorithm and can locate the row
directly. Hashing provides fast retrieval for data that
contains a unique key value.
Note that a hash value cannot be converted back to the
original value.
| Is This Answer Correct ? | 4 Yes | 1 No |
Post New Answer View All Answers
What is procedure and function in sql?
What is sql*loader and what is it used for?
what does it mean to have quoted_identifier on? What are the implications of having it off? : Sql dba
What is loop in pl sql?
How many sql core licenses do I need?
What is recursive join in sql?
What is pl sql variable?
What is difference between inner join and cross join?
What is the difference between an inner join and an outer join?
What is 19 null in sql?
what is the difference difference between procedure and packages
What is join view in sql?
How do you optimize a query?
What are local and global variables and their differences?
What are the set operators in sql?
