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 bind plan?
What is the syntax for creating a table in the db2 database?
What are the full forms of spufi and dclgen and why are they used?
What is the usage of open cursor command?
What is a db2 package?
What is the maximum size of a char data type in db2?
How does cobol compile db2 program?
What is explain plan in db2?
Which component is used to execute the sql statements?
Which command is used to connect to a database in DB2 ? Give the Syntax.
What are iseries servers?
Why do we need reorg in db2?
Explain in detail about buffer manager and its functionalities?
What does db2 stand for?
What is the role of union all and union
