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 we use ddl statements in stored procedure sql server?

1013


What is difference between joins and union?

1129


How show all rows in sql?

1015


Why is sql*loader direct path so fast?

1107


how to fetch alternate records from a table? : Sql dba

1114


What is left inner join in sql?

1047


how to check server status with 'mysqladmin'? : Sql dba

1077


GLOBAL TEMPORARY TABLE over Views in advantages insolving mutating error?

3052


How many types of tables are there?

952


What is the difference between a primary key and a clustered index?

993


How to execute a stored procedure?

1095


What is pl sql in dbms?

954


Why do we create views in sql?

1155


Do we need to create index on primary key?

929


What is a nested table in word?

961