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 node in db2?
Define data page.
How do you stop a db2 database in linux?
Is db2 a mainframe?
Which component is used to execute the sql statements?
Which is faster delete or truncate?
List out the three types of page locks that can be held.
How can we read records for specific member in CL? AND rpg?
What is null indicator in cobol db2?
What types of tables are there in the db2 database?
How to view db2 table structure?
What is the cobol picture clause of the db2 data types date, time, timestamp?
How to execute stored procedure in db2 command editor?
How to take backup of table in db2?
Mention the location where the output received from explain statement is stored.