What will the FREE command do to a plan?

Question Posted / guest

2 Answers
4841 Views
I also Faced
E-Mail Answers

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

4. A DB2 application is bound with uncommitted Read isolation level.It issues a request that retrieves 20 rows out of 200000 in the table. Which of the following descrbes the rows that are locked as a result of this request? a. None of the rows are locked. B.The retrieved rows are locked. C.The last row of the result set is locked. D.The rows not previously updated by another application are locked.

3 Answers Wipro,

which SQL comment successfully removes uncommitted changes from a DB2 database A) rollback B) delete C) drop D) decommit

2 Answers Accenture, Wipro,

What is dclgen in db2?

0 Answers

what is different three logs in DB2?

1 Answers Syntel,

How do you leave the cursor open after issuing a COMMIT? (for DB2 2.3 or above only)

2 Answers

What is meant by AUTO COMMIT?

3 Answers

How does the processing of a correlated subquery differ from a non correlated subquery?