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
Is oracel sql developer written in java?
How do you declare a user-defined exception?
What pl/sql package consists of?
What is the difference between a query and a report?
How many types of keys are there in sql?
Is full outer join same as cross join?
Explain exception handling in pl/sql?
What is a boolean in sql?
How does stored procedure reduce network traffic?
Which is faster joins or subqueries?
what are aggregate and scalar functions? : Sql dba
Which tcp/ip port does sql server run?
What is union and union all keyword in sql and what are their differences?
Can we use commit inside a trigger?
Define join and name different types of joins?
