Interested to Buy Any Domain ? << Click Here >> for more details...
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 the difference between microsoft access and sql?
How many row comparison operators are used while working with a subquery?
what are the advantages of sql ? : Sql dba
What is the purpose of the primary key?
what is the difference between a local and a global temporary table? : Sql dba
What sql database should I use?
What operators deal with null?
Is primary key is clustered index?
Which join condition can be specified using on clause?
How do you sort in sql?
How does cross join work?
Which is the correct statement about truncate and delete?
The in operator may be used if you know the exact value you want to return for at least one of the columns.
What are basic techniques of indexing?
what is the difference between truncate and drop statements? : Sql dba
