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 is node in db2?

985


Define data page.

1011


How do you stop a db2 database in linux?

956


Is db2 a mainframe?

965


Which component is used to execute the sql statements?

1051


Which is faster delete or truncate?

1068


List out the three types of page locks that can be held.

1090


How can we read records for specific member in CL? AND rpg?

643


What is null indicator in cobol db2?

991


What types of tables are there in the db2 database?

1003


How to view db2 table structure?

959


What is the cobol picture clause of the db2 data types date, time, timestamp?

1007


How to execute stored procedure in db2 command editor?

983


How to take backup of table in db2?

1020


Mention the location where the output received from explain statement is stored.

1053