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
What is anonymous block in sql?
What is a dynamic query?
What is data control language (dcl)?
What are the operators in sql?
What is a join query?
What is nested table in pl sql?
What is data modelling in sql?
Can one improve the performance of sql*loader? : aql loader
Can a table contain multiple foreign key’s?
What is normalization? How many normalization forms are there?
What is mutating error?
What are two statement types in sql?
What are the different operators available in sql?
What is the usage of nvl function?
explain the delete statements in sql