Interested to Buy Any Domain ? << Click Here >> for more details...
What is reorg in database?
- 1 Answers
- 2131 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 |
i want to maintain uniqueness on pdf without make lf??????????
what is a corelated subquerry?
What is FREEPAGE and PCTFREE in TABLESPACE creation?
Consider that a package is bound into 2 different collections and the PKLIST option specifies both the collections. If the collection id is not specified in the program while executing the SQL query, then when the DB2 system will search the package list, which collection will it pick up or will it give an error/abend?
What is meant by dclgen?
Explain the contention situations caused by locks?
Explain an outer join?
Could anyone clearly explain the diference between sub query and correlated sub query?
What is difference between rollback and commit?
Explain what a plan is?
What are foreign keys in db2?
What is the syntax for creating a table in the db2 database?
COBOL 
