What is a DB2 plan?

Answer Posted / vira raguram.i

a plan is an executable module containing the access path
logic produced by the db2 optimizer.it can have one or more
DBRMs or packages.

Is This Answer Correct ?    14 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to take backup of table in db2?

598


How can the firstname and the lastname from the emp table be concatenated to generate complete names?

743


What is scrollable cursor in db2?

579


Explain the contention situations caused by locks?

589


Explain about cursor stability?

619






What is schema in db2?

572


What is the difference between nvl and coalesce?

600


How to check table size in db2 sap?

574


Which is faster delete or truncate?

673


Can you use max on a char column?

638


What is role in db2?

612


What is plan in cobol db2?

589


Explain the contents that are a part of dclgen.

653


Explain about mirror activator disk mirroring?

556


How can we read records for specific member in CL? AND rpg?

228