Answer Posted / harish
Reorg is needed whenever indexed columns are updated frequently.
When indexed columns are updated frequently, then the index
for the table has to be created again.
So REORG utility is run which will drop the index and create
the index again for the table.
Is This Answer Correct ? | 36 Yes | 5 No |
Post New Answer View All Answers
What is temporal table in db2?
What is nvl in db2?
What is image copy in db2?
What is plan in cobol db2?
What os does db2 run on?
Explain the contents that are a part of dclgen.
What is the difference between dbm cfg and db cfg file in db2 ?
What is iseries database?
How to access db2 tables in mainframe?
Why do we need reorg in db2?
Why do chiropractors use drop table?
How to find primary key of a table in db2?
On which levels locks can be applied?
How to get the ddl of a table in db2?
My sql statement select avg(salary) from emp yields inaccurate results. Why?