What is reorg in database?
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 does the REORG Utility do?
How does cobol compile db2 program?
Mention the various locks that are available in db2.
What is iseries database?
How can you split a table in to exactly half?
What is an inner join, and an outer join ?
What does db2 mean?
How to handle null values in db2
How do I connect my db2 database to ibm?
What is release/acquire in bind?
how 2 resolve the -311 sqlcode
I have a subprogram B calling from mainprogram A.I have opened a cursor in A ,Can i fetch the same cursor in subprogram B , If yes , Please explain the reason?