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 is rebinding ?



what is rebinding ?..

Answer / sravani

when sql statements are not changed but a new index is added or runstats is run,then it is advisable to do a rebind for the
best possible access path. rebind plan is cheaper than bind with action(replace)

Is This Answer Correct ?    4 Yes 0 No

Post New Answer

More DB2 Interview Questions

the dd name for ksds is dest1 and what is the dd name for alternate index of ksds ? a.dest b.dest1 c.dest1a d.dd1

2 Answers   Logica CMG,


How can the firstname and the lastname from the emp table be concatenated to generate complete names?

0 Answers  


what's the error code for Unique Index Violation?

2 Answers  


Give some example of statistics collected during RUNSTATS?

1 Answers  


How to know the primary key of a table without defining the primary key in the table?

5 Answers   Satyam,


what types of copies can be made with the COPY Utility ?

1 Answers  


List down the types of triggers in the db2 database?

0 Answers  


How and when does the db2 enforces the unique key?

0 Answers  


What is host variable?

0 Answers  


How does cobol compile db2 program?

0 Answers  


In cursor program perform para varying until 1 by 1 fetch para cursor------close para in the blank what will come for confirming in the database?

1 Answers   HCL,


What is data manager?

0 Answers  


Categories