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

How can I speed up sql query?

935


Can we call procedure in select statement?

1034


Is sql similar to python?

959


What is the basic form of sql query?

922


What is the difference between the conventional and direct path loads? : aql loader

1374


What are the types of join and explain each?

1019


What are sql indexes?

978


How to test for null values?

1021


How can a function retun more than one value in oracle with proper example?

1061


What is crud sql?

962


What are sql objects?

1063


What do you know by pl/sql cursors?

1087


How to use sql statements in pl/sql?

1095


What is the use of stored procedures?

1021


What are tables and fields in the database?

1092