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 most important ddl statements in sql are?
How to avoid using cursors? What to use instead of cursor and in what cases to do so?
How to change sql*plus system settings?
What is union and union all keyword in sql and what are their differences?
What is recursive stored procedure?
Mention what are the benefits of pl/sql packages?
What is difference between inner join and cross join?
What is an emotional trigger?
Can delete statement be rollbacked?
Write a program that shows the usage of while loop to calculate the average of user entered numbers and entry of more numbers are stopped by entering number 0?
what is error ora-03113: end-of-file on communication channel?
how can I make a script that can be bi-language (supports english, german)? : Sql dba
Is ms sql is free?
How delete all records from table in sql?
How do you clear the screen in sql?