What is reorg in database?
- 1 Answers
- 1544 Views
- I also Faced
- E-Mail Answers
Answer / 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 |
What is cursor stability?
What are db2 objects?
What is the difference between Where and Having Clause
can any body explain about plan and pakage in detail....
what are the copybook changes generally we done?can anyone tell me......... Thanks in advance........
can we drop column from a table
What is an asychronous write?
What is bind in db2?
What is db2 catalog database?
What is performance tuning db2?
How do I create a table MANAGER (EMP-NO, MANAGER) where MANAGER is a foreign key which references to EMP-NO in the same table? Give the exact DDL.
What is the use of with ur in db2?
COBOL 
