What will the FREE command do to a plan?

Answer Posted / s

Drops the plan.

Is This Answer Correct ?    4 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to find schema of a table in db2?

573


What is buffer pool and list some of them?

630


can all users have the privilage to use the sql statement select * (dml)?

644


How to retrieve rows from a db2 table in embedded sql?

730


What is a page in db2?

613






What is difference between rollback and commit?

636


How do we specify index to include or not during bind process.

1674


What is the reason behind not using select * in embedded sql programs?

606


Outputs of explain are with matchcols = 0. What does this signify?

622


How and when does the db2 enforces the unique key?

618


What is check constraint in db2?

611


What is bufferpool in db2?

580


Is db2 a database?

574


What's The Error Code For Unique Index Voilation?

656


What is the difference between plan and package in db2?

581