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 reorg in DB2

Answer Posted / harish

Reorg is needed whenever indexed columns are updated frequently.

When indexed columns are updated frequently, then the index
for the table has to be created again.

So REORG utility is run which will drop the index and create
the index again for the table.

Is This Answer Correct ?    36 Yes 5 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Mention some fields that are a part of sqlca.

970


What is performance tuning db2?

1007


Hello All, We have requirment to Replace BMC Db2 Load product thru CA FAST LOADPlus product. Do anyone have JCL to for FAST LOADPLUS and what all are thing need to take in consideration.

2667


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

2098


What is buffer pool in the db2 database?

1046


Why do chiropractors use drop table?

1045


what is the sqlcode -501

12919


Define declaration generator (dclgen).

1067


How do I add a column in db2?

997


Is it possible to create an Instance in DB2 using DB2 Control Center ?

1041


How can you do the explain of a dynamic sql statement?

1013


Can you use max on a char column?

1027


What is a db2 collection?

981


What is host variable?

1012


What is database manager in db2?

966