what is REORG? what is the use?
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / s
It is not necessary to run the REORG utility after the Load
utility unless the data needs to be reclusterd based on the
clustering sequence and reclaim free space. If the data
input to the load data is already sorted in clustering
sequence the need for a REORG is unnecessary.
Is This Answer Correct ? | 4 Yes | 0 No |
Answer / deepak dada
used for reorganising the datas in the tables after the
load utility
Is This Answer Correct ? | 1 Yes | 0 No |
What happens to a tablespace when its recovery infromation has been removed and a full recovery is no longer possible?
how to identify the pseudo conversation by seeing the program
What db2 400?
Mention the downsides of page level lock.
What is bufferpool in db2?
How do I connect my db2 database to ibm?
Is db2 relational database?
What is the use of commit in db2?
What is the role of the data page in the db2 database?
What is the difference between spufi and qmf?
What is netezza database?
How to take backup of table in db2?