What will the FREE command do to a plan?

Answers were Sorted based on User's Feedback



What will the FREE command do to a plan?..

Answer / s

Drops the plan.

Is This Answer Correct ?    4 Yes 0 No

What will the FREE command do to a plan?..

Answer / sv kumar

it will delete that existing plan

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More DB2 Interview Questions

What does reorg do in db2?

0 Answers  


what is the input to PLAN? what is the input to DBRM?

4 Answers  


What is reorg?

0 Answers  


i want to maintain uniqueness on pdf without make lf??????????

0 Answers  


What is phantom read in db2?

0 Answers  






What is db2 plan table?

0 Answers  


in a table consist of 1000 records among that i was updated 145 record how could i know that ..list of recently updated record's and where could i see those updated record's....pls help me out....

4 Answers   Infosys,


What is REORG? When is it used?

4 Answers  


What is dynamic SQL?

1 Answers   ADP,


What are common abends

1 Answers   SPIC, Virtusa,


What is the use of runstats in db2?

0 Answers  


pls tell me abt the normalization five types....

2 Answers  


Categories