Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / vasuki🐍
reorganizes the table and its indexes by
rebuilding the index data into unfragmented and contiguous area on the disk.
Normally after a large amount of INSERT, UPDATE, DELETE activities on data tables, we generally need a REORG.
After a table space reorganization the fragments are moved around and clustered,
however the database still utilizes the old statistic to query the data.
So it is recommended to run a RUNSTATS on the table.
This command updates the statistic information.
Besides it makes sure that the DB2 optimizer takes advantage of the refreshed statistic information.
Reorg>>runstats
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What db2 400?
How will you return the number of records in table?
What is sqlca?
Which isolation level provides highest data integrity?
How to find the number of rows in a db2 table?
How does cobol compile db2 program?
what is utility for parm lib
List out the data types available.
Which command is used to remove all rows from a table?
What are the prerogatives?
What is cursor stability in db2?
What does a deadlock mean in DB2?
What is cascading rollback?
What is buffer pool and list some of them?
Is ibm db2 open source?
