What will the FREE command do to a plan?

Answer Posted / sv kumar

it will delete that existing plan

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is with ur in db2?

753


What is the use of commit in db2?

628


While unloading huge amount of data from table. Suddenly job failed some error. Imagine 1M data unloading, In that 90% data unloaded only 10% left, So if want to unload the rest 10% what needs to be done? Whether do i need to start from top or anything ?

1818


Discuss about db2 bind?

668


What does db2 stand for?

596






What is the difference between nvl and coalesce?

600


Can we update view in db2?

558


How do I change the column size in db2?

589


What is difference between rollback and commit?

625


What is dbrm? What it contains?

679


What do you mean by commit and rollback?

592


Why cursor is used in db2?

572


How to find the number of rows in db2 tables?

614


What do you mean by storage group (stogroup)?

581


What is multi row fetch in db2?

601