Answer Posted / 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 |
Post New Answer View All Answers
How to read xml file in oracle pl sql?
how can we destroy the cookie? : Sql dba
What does (+) mean in sql joins?
Is it possible to pass parameters to triggers?
Is microsoft sql free?
Is grant a ddl statement?
Can we write ddl statements in functions?
Does sqlite need a server?
How do you know if a relationship is 2nf?
What is transaction control language (tcl)?
Define overloaded procedure?
What is sql*loader and what is it used for?
What is mdb stand for?
How do you concatenate in sql?
What is self-join and what is the requirement of self-join?