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 are the types of subqueries?
How many disk partitions should I have?
How do I save a stored procedure?
How to look at the current sql*plus system settings?
What is an escape character in sql?
explain advantages of innodb over myisam. : Sql dba
How delete all data from all tables in sql?
What does := mean in pl sql?
What is field delimiter?
What are local and global Indexes and where they are useful.
what is self-join? : Sql dba
how to show all tables with 'mysql'? : Sql dba
Can a table contain multiple primary key’s?
How to call a javascript function from pl sql?
What is procedure explain with program?