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
Can sql function call stored procedure?
which operator is used in query for pattern matching? : Sql dba
how to convert character strings to dates? : Sql dba
How many sql databases can you have on one server?
Do we need to create index on primary key?
what are date and time intervals? : Sql dba
what is a cursor? : Sql dba
what is the difference between where clause and having clause? : Sql dba
Is json a nosql?
Is vs as in pl sql?
what is the syntax used for partition in tsql? : Transact sql
What are data types in pl sql?
Why join is faster than subquery?
What are sql data types?
what is foreign key? : Sql dba