Interested to Buy Any Domain ? << Click Here >> for more details...
What is reorg in database?
- 1 Answers
- 1948 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 a thread?
Usually, which is more important for DB2 system performance - CPU processing or I/O access?
Do we need cursor for Count(*)?
how can we find nth max salary from A table
What is a DB2 catalog?
What is a Foreign Key?
0 Answers Tavant Technologies, Zensar,
What are some characteristics of columns that benefit from indexes?
What is a db2 schema?
What is IMAGECOPY ?
What are simple, segmented and partitioned table spaces ?
How many databases are there?
What is load replace in db2?
COBOL 
