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...

  1. Categories >> Software >> MainFrame >> IBM MainFrame >> DB2
  2. Suggest New Category

Compare a subselect to a join?

Question Posted / sunil1405

Answer Posted / sunil1405

join is more efficeint, Subselect can be written as a join.

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Name the various locking levels available?

1137

What is with ur in db2?

1385

What is the use of runstats in db2?

1184

How do you find the maximum value in a column in db2?

1155

How to resolve deadlock issue

20329

What is explain plan in db2?

1052

How to get the ddl of a table in db2?

1170

What is the result of open cursor statement?

1129

How do I add a column to a table in db2?

1161

Outputs of explain are with matchcols = 0. What does this signify?

1113

What is the syntax for creating a table in the db2 database?

1150

Is db2 relational database?

1047

I HAVE 500 ROW TO UPDATE I WOULD LIKE TO USE ROLLBACK ALONG WITH COMMIT.WHAT IS THE SYNTAX TO CODE COMMIT AND ROLLBACK FOR EVERY 100 ROWS.AND HOW THE CURSOR ROLLBACK TO THE LAST COMMITTING POINT.

3266

What is a buffer in memory?

1112

What is the meaning concurrency in the db2 database?

1170