Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

  1. Categories >> Software >> MainFrame >> IBM MainFrame >> DB2
  2. Suggest New Category

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

Question Posted / guest


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

Answer / 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

Post New Answer

More DB2 Interview Questions

how to execute qcmdexc in rpgle?plz write code also?

1 Answers   IBM,

What is db2 look?

0 Answers  

What does reorg do in db2?

0 Answers  

What is dbrm?

0 Answers  

what is the input to PLAN? what is the input to DBRM?

4 Answers  

What is a root page?

1 Answers  

What are the rules for db2 programming?

0 Answers  

What are the three lock types?

2 Answers  

What is pagespace?

1 Answers  

can I alter a table (e.g. adding a column) when other user is selecting some columns or updating some columns from the same table?

1 Answers  

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

0 Answers  

a cursor normally gets closed once we provide a commit . If u try to close the same cursor with close cursor command later after providing the commit will there be any sql-error.

3 Answers  

For more DB2 Interview Questions Click Here
Categories