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 / guest


Compare a subselect to a join?..

Answer / sunil1405

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

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More DB2 Interview Questions

What is a buffer in memory?

0 Answers  

What is bufferpool in db2?

0 Answers  

which is the most efficient tablespace?? a.simple tablespace. b.partitioned tablespace. c.segmented tablespace. d.none of the above. please post answer with the reason.?

3 Answers  

What is clone table?

0 Answers  

What is an inner join, and an outer join ?

1 Answers   CTA,

In SPUFI suppose you want to select maximum of 1000 rows, but the select returns only 200 rows. What are the 2 SQLCODEs that are returned?

1 Answers  

How do you simulate the explain of an embedded sql statement in spufi/qmf?

0 Answers  

How to retrieve rows from a db2 table in embedded sql?

0 Answers  

What is the difference between drop table and delete table?

0 Answers  

B37 abend during spufi?

0 Answers   IBM,

What is the difference between using bind () and rebind () methods of naming class?

0 Answers  

Describe what a storage group(STOGROUP) is?

2 Answers  

For more DB2 Interview Questions Click Here
Categories