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...

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

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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are db2 objects?

1046


What is dclgen (declaration generator)?

1059


How many databases are there?

1054


Comment whether dclgen is mandatorily used. If not, then what is the point of using it?

1061


What is innodb buffer pool?

1055


What is view db2?

1076


What does runstats do in db2?

1119


What is a db2 tablespace?

1066


What is role in db2?

1109


How do I create a view in db2?

1024


What is the physical storage length of time data type?

1129


How connect db2 database to datastage?

1243


What is the difference between using bind () and rebind () methods of naming class?

1401


Why do we use cursor?

1100


How can you validate Sql errors during cursor operation in db2 pgms and where do you code?

2215