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
Does truncate require commit?
How to display the records between two range in Oracle SQL Plus?
How many triggers can be applied on a table?
What are the uses of merge?
Why do we use procedures in sql?
what is not null constraint? : Sql dba
What is user defined functions?
What are the methods of filing?
Are dml statements autocommit?
Whis is not false in primary key?
Can pl sql procedure have a return statement?
how to get a list of all tables in a database? : Sql dba
What is microsoft t sql?
what are the type of locks ? : Sql dba
How can I make sql query run faster?
