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? what is the use?

Answer Posted / aasif

A common maintenance task performed by database
administrators is the reorganization of data in tables and
indexes, called "reorg." Table reorganization is used to
defragment a table, reclaim free space, and eliminate
overflow rows in order to improve data access performance.
Optionally it can be used to reorder data in the order of a
particular index, to optimize queries that use that index.

Is This Answer Correct ?    10 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What language is db2 written in?

1052


What is the advantage in De-normalizing tables in DB2?

1185


How to create backup table in db2?

1098


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

1077


What is db2 plan table?

1054


What is isolation level in db2?

1015


Why do chiropractors use drop table?

1114


How do I delete a table in db2?

1083


What is difference between alias and synonym in db2?

1149


ther r 2 tables OTTABLE & SALTABLE, add the otamt from OTTABLE to empsal of SALTABLE if eid is matched else add the unmatched from OTTABLE to SALTABLE

2073


What is ibm db2 client?

947


can we view the access paths created by dbrm ? how ? thx

7107


What is the difference between oracle and db2?

1117


What is page size in db2?

984


Define buffer pool.

1063