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 online transaction processing (oltp)?
mention if it is possible to import data directly from t-sql commands without using sql server integration services? If yes, what are the commands? : Transact sql
Does asenumerable execute the query?
What is trigger types of trigger?
What is difference between sql function and stored procedure?
What is on delete restrict?
how to calculate expressions with sql statements? : Sql dba
What type of database is sql?
What is the difference between clustered and non-clustered index in sql?
what is a database? : Sql dba
Is record in oracle pl sql?
What is union and union all keyword in sql and what are their differences?
What is the purpose of normalization?
What is the sql*loader? : aql loader
does sql support programming? : Sql dba