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 can I speed up sql query?
Can we call procedure in select statement?
Is sql similar to python?
What is the basic form of sql query?
What is the difference between the conventional and direct path loads? : aql loader
What are the types of join and explain each?
What are sql indexes?
How to test for null values?
How can a function retun more than one value in oracle with proper example?
What is crud sql?
What are sql objects?
What do you know by pl/sql cursors?
How to use sql statements in pl/sql?
What is the use of stored procedures?
What are tables and fields in the database?