Compare a subselect to a join?

Question Posted / guest

Compare a subselect to a join?..

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

Is This Answer Correct ?

0 Yes

0 No

More DB2 Interview Questions

What's The Percentage Free Space ?

How do you declare a host variable (in COBOL) for an attribute named emp-name of type VARCHAR(25) ?

How can you quickly find out the # of rows updated after an update statement?

What is the meaning of -805 SQL return code?

What is the max length of sqlca?

How can the duplicate values be eliminated from db2 select?

where will u check for sqlcode ?

What is the role of the data page in the db2 database?

What is consistency token in db2?

What is the cobol picture clause of the db2 data types date, time, timestamp?

Is Cursor exicutable ?

What is the difference between a package and a plan?

For more DB2 Interview Questions Click Here