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 indexes?
Explain the difference in execution of triggers and stored procedures?
What are secondary keys?
How to rename a table?
Is sqlite free?
Does truncate release storage space?
Define sql delete statement.
How can I speed up sql query?
How do you declare a constant?
How much does sql certification cost?
What is the difference between distinct and unique in sql?
What is a sql schema used for?
Is sql an operating system?
What problem one might face while writing log information to a data-base table in pl/sql?
What is interval partition?