Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...


what is HASH join?

Answers were Sorted based on User's Feedback



what is HASH join?..

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

what is HASH join?..

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

Post New Answer

More SQL PLSQL Interview Questions

How can you maintain the integrity of your database on instances where deleting an element in a table result in the deletion of the element(s) within another table?

0 Answers  


table - new_no old_no 2345 1234 3456 2345 5678 4567 output sud be -new_no 1234 2345 3456 4567 5678

2 Answers  


What are different types of sql commands?

0 Answers  


What is an index in sql with example?

0 Answers  


Can you have multiple SPs with the same name on a database?

6 Answers   CGI,






What is the difference between cross join and natural join?

0 Answers  


what is self join and why is it required? : Sql dba

1 Answers  


What is sql key?

0 Answers  


What is an index? What are the types of indexes? How many clustered indexes can be created on a table?

0 Answers  


what is “go” in t-sql? : Transact sql

0 Answers  


what are different types of keys in sql?

0 Answers  


what are the differences between public, private, protected, static, transient, final and volatile? : Sql dba

0 Answers  






Categories