The plan is invalidated and an automatic rebind is attempted next time is

What happens to the PLAN if index used by it is dropped?

Question Posted / s

Answer Posted / s

The plan is invalidated and an automatic rebind is
attempted next time is the plan is executed.

Is This Answer Correct ?

4 Yes

0 No

Please Help Members By Posting Answers For Below Questions

Which are the db2 tools to protect integrity of the database?

1073

What are the benefits of using the db2 database?

1156

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

2099

Define buffer pool.

999

Are view updateable?

984

Mention the way of highlighting as well as putting a cursor to use in a cobol program.

1020

What is data manager?

995

What is netezza database?

960

What is null indicator in db2?

1054

How connect db2 database to datastage?

1190

What is with ur in db2?

1245

What is commit in db2?

998

Is it possible using max on a char column?

1086

What do you mean by cursor?

942

Can there be more than one cursor open for any program?

1124