Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

what is HASH join?

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


Please Help Members By Posting Answers For Below Questions

Can sql function call stored procedure?

1074


which operator is used in query for pattern matching? : Sql dba

1045


how to convert character strings to dates? : Sql dba

1098


How many sql databases can you have on one server?

1152


Do we need to create index on primary key?

966


what are date and time intervals? : Sql dba

1105


what is a cursor? : Sql dba

1066


what is the difference between where clause and having clause? : Sql dba

1044


Is json a nosql?

1032


Is vs as in pl sql?

1037


what is the syntax used for partition in tsql? : Transact sql

1060


What are data types in pl sql?

1197


Why join is faster than subquery?

1159


What are sql data types?

1072


what is foreign key? : Sql dba

1107