Compare a subselect to a join?

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

How to execute stored procedures?

622


Define data page.

634


What is release/acquire in bind?

656


What does sqlcabc has?

633


How do I delete a column in db2?

680






What are the contents of dclgen?

658


What is phantom read in db2?

638


Explain dclgen.

724


Which components manage deadlocks in db2?

614


What is difference between isnull and coalesce?

620


Highlight all the advantages that are attached to a package.

629


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

592


What is syscat in db2?

579


Which component is used to execute the sql statements?

620


How do I create a view in db2?

606