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
How do I pipe the output of one isql to another?
What is cursor in pl sql with examples?
What is cartesian join in sql?
What is user defined functions?
What program will open a mdb file?
Determine if oracle date is on a weekend?
How do I clear the screen in sql plus?
Is the primary key an index?
How does an execution block start and end in pl sql?
What are the advantages of pl sql over sql?
Is left join same as join?
Can we group by two columns in sql?
Write a sql select query that only returns each name only once from a table?
What are operators available in sql?
how to increment dates by 1 in mysql? : Sql dba
