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
What is load utility in db2?
How to find schema of a table in db2?
What is check constraint. Explain with example.
What is the difference between nvl and coalesce?
What is concurrency?
What is check constraint in db2?
What's The Error Code For Unique Index Voilation?
What is cloudant database?
What is the difference between spufi and qmf?
What is the role of the data page in the db2 database?
What is meant by union and union all?
How can you quickly find out the # of rows updated after an update statement?
What is db2 and what is the use of db2 optimizer?
What are bind parameters in db2?
My sql statement select avg(salary) from emp yields inaccurate results. Why?