what is HASH join?
Answers were Sorted based on User's Feedback
Answer / avi007
Hash joins do not use indexes and perform full-table scans
often using parallel query. Hence, the use of hash joins
with parallel full-table scans tend to drive-up CPU
consumption.
Is This Answer Correct ? | 9 Yes | 2 No |
Answer / 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 |
What is the primary use of normalization?
Define sql delete statement.
What is the usage of distinct keyword?
What are different types of queries in sql?
Name some usages of database trigger?
What is Histogram?
what are enums used for in mysql? : Sql dba
Difference between SUBSTR and INSTR?
What is the process of copying data from table a to table b?
Can we use commit inside a trigger?
how do you login to mysql using unix shell? : Sql dba
what is 'mysqlshow'? : Sql dba