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 is difference between isnull and coalesce?
Why select is not preferred in embedded sql programs?
What is explain in db2?
Explain dclgen.
Define check constraint.
What does db2 blu stand for?
How can you count the number of rows from a table tab?
What is a cursor in programming?
What does db2 plan contain?
Is db2 a mainframe?
Define sqlca.
How to retrieve rows from a db2 table in embedded sql?
How do you stop a db2 database in linux?
What is db2 optimizer?
What are the bind parameters ibm db2?
