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

In case if at some point of time db2 is down, would that impact the pre-compilation process of a db2-cobol program?

1027

What is a dbrm in db2?

1010

Is it possible to create an Instance in DB2 using DB2 Control Center ?

1084

Which component is responsible for processing sql statements and selecting access paths?

1116

What is load utility in db2?

1167

What is the difference between "db2ilist" and "db2 get instance" commands in DB2 Database Server?

1255

What is cursor in dbms?

1048

What is the physical storage length of time data type?

1109

What is db2?

1161

How to find the number of rows in a db2 table?

1105

For a db2 column that is being defined as decimal (11, 2), discuss the cobol picture clause.

1094

What is a db2 collection?

1022

What does a deadlock mean in DB2?

1151

What is dbrm library?

1036

Comment whether the cursor is closed during commit or not.

1081