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
Mention some fields that are a part of sqlca.
What is performance tuning db2?
Hello All, We have requirment to Replace BMC Db2 Load product thru CA FAST LOADPlus product. Do anyone have JCL to for FAST LOADPLUS and what all are thing need to take in consideration.
i want to maintain uniqueness on pdf without make lf??????????
What is buffer pool in the db2 database?
Why do chiropractors use drop table?
what is the sqlcode -501
Define declaration generator (dclgen).
How do I add a column in db2?
Is it possible to create an Instance in DB2 using DB2 Control Center ?
How can you do the explain of a dynamic sql statement?
Can you use max on a char column?
What is a db2 collection?
What is host variable?
What is database manager in db2?