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 the information associated with sysibm.syslinks table?
What are the various isolation levels possible?
What type of database is db2?
Is db2 relational database?
What is a plan and package in db2?
In an sql table that is embedded, what is the procedure to retrieve rows that are part of a db2 table?
What are the rules for db2 programming?
What is dbrm?
What happens in bind step in a db2 program?
What are db2 tables?
Describe major components of db2?
What are the uses of db2 optimizer?
What is cloudant database?
i want to maintain uniqueness on pdf without make lf??????????
Explain the function of data manager.
