Interested to Buy Any Domain ? << Click Here >> for more details...
what is HASH join?
- 2 Answers
- 12602 Views
- Genpact, HCL, I also Faced
- E-Mail Answers
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 primary key secondary key alternate key candidate key?
What is pl sql quora?
What is data abstraction in sql?
what is mean by forward declaration and where we'll use it.
What is right join in sql?
What is denormalization in a database?
What is a transaction?
four procedures is are there should i write their in a package
Write a query to find the names of users that begin with "um" in sql?
What is the difference between delete and truncate statement in sql?
What is Histogram?
what is oracle sql,pl/sql with interfaces
-
Oracle (3259) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3330)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1411)
- Databases AllOther (288)
