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 ?

Answer Posted / 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       View All Answers


Please Help Members By Posting Answers For Below Questions

What is the latest version of ibm db2?

1203


How to check last update on table in db2?

1004


Define declaration generator (dclgen).

1068


i want to maintain uniqueness on pdf without make lf??????????

2099


How do you concatenate the firstname and lastname from emp table to give a complete name?

1016


What is a storage group (stogroup)?

1189


What is scrollable cursor in db2?

999


What is the maximum size of varchar data type in db2?

1068


How connect db2 database to datastage?

1190


Mention some fields that are a part of sqlca.

972


List out the buffer pools in db2

1023


What is a bind card?

1145


What is cloudant database?

1034


What is innodb buffer pool?

982


How do I add a column in db2?

1000