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
What is null in db2?
In an sql table that is embedded, what is the procedure to retrieve rows that are part of a db2 table?
What is the difference between cursor stability and repeatable read isolation levels?
What is db2 command?
What is bufferpool in db2?
What is an instance in db2?
What is the role of schema in the db2 database?
What is lock escalation in db2?
I HAVE 500 ROW TO UPDATE I WOULD LIKE TO USE ROLLBACK ALONG WITH COMMIT.WHAT IS THE SYNTAX TO CODE COMMIT AND ROLLBACK FOR EVERY 100 ROWS.AND HOW THE CURSOR ROLLBACK TO THE LAST COMMITTING POINT.
What is sqlca’s maximum length?
How do I change the column size in db2?
What is view db2?
what is diffrence b/w file-aid tool and file-aid utility???
can any one provide me the link for the db2 v7 & db2 v8 manual for Z/os? i need to know about the syntax of REORG in both versions & need to know the difference as well
What is db2 optimizer?
