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 language is db2 written in?
What is the advantage in De-normalizing tables in DB2?
How to create backup table in db2?
How do you concatenate the firstname and lastname from emp table to give a complete name?
What is db2 plan table?
What is isolation level in db2?
Why do chiropractors use drop table?
How do I delete a table in db2?
What is difference between alias and synonym in db2?
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
What is ibm db2 client?
can we view the access paths created by dbrm ? how ? thx
What is the difference between oracle and db2?
What is page size in db2?
Define buffer pool.