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

WHAT IS NULL INDICATOR ? WERE IS THIS USED? AND IF IT IS USED IN FILES CONCEPT? HOW DO WE USE IT?

2 Answers   IBM,

What is the significance of DB2 free space and what parameters control it?

1 Answers  

What is sqlcode -811?

7 Answers   Accenture, CTS, TCS,

how to unload different table data into different gdg files/ vsam files.

3 Answers  

Explain packages.

0 Answers  

Do we need cursor for Count(*)?

4 Answers   iGate,

Can I use LOCK TABLE on a view?

1 Answers  

What is a Database Request Module(DBRM)?

4 Answers  

What is a subselect? Is it different from a nested select?

1 Answers  

What is the difference between dbm cfg and db cfg file in db2 ?

0 Answers   MCN Solutions,

Can we use select * statement in cobol program without giving field names ???

3 Answers   Zensar,

if suppose i am having an ACCOUNT table with 3 coloumns ACC. NO,ACC. NAME,ACC. AMOUNT . If a unique index is also defined on ACC.NO and ACC.NAME then write a query to retrieve account holders records who have more than 1 ACC.

8 Answers   Wipro,

For more DB2 Interview Questions Click Here
Categories