Interested to Buy Any Domain ? << Click Here >> for more details...
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
How to take backup of table in db2?
How do I connect my db2 database to ibm?
What is reorg?
What is the physical storage length of the data types: date, time, timestamp in the db2 database?
How do I delete a column in db2?
What is a plan and package in db2?
Who uses db2?
What are host variables in db2?
Define db2.
can we view the access paths created by dbrm ? how ? thx
What is node in db2?
What is cascading rollback?
What is page size in db2?
Mention the location where the output received from explain statement is stored.
My sql statement select avg(salary) from emp yields inaccurate results. Why?
