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 is the picture clause of the null indicator variable?
How is a typical DB2 batch program executed ?
I have a subprogram B calling from mainprogram A.I have opened a cursor in A ,Can i fetch the same cursor in subprogram B , If yes , Please explain the reason?
How can you quickly find out the number of rows updated after an update statement?
What is the difference between "db2ilist" and "db2 get instance" commands in DB2 Database Server?
How do you check for a null value in a db2 column?
What is difference between rollback and commit?
what is difference between Plan and Package
how to resolve -811 error. give clear explination
What is cursor stability?
What is CHECK PENDING ?
What is rebind in db2?