Interested to Buy Any Domain ? << Click Here >> for more details...
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 max length of sqlca?
What is performance tuning db2?
How do you concatenate the firstname and lastname from emp table to give a complete name?
Where can you declare a cursor in a cobol-db2 program?
Can we update view in db2?
What is query_cache_limit?
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.
Which component is used to execute the sql statements?
What is commit in db2?
List some fields from sqlca?
Mention the definition of cobol in varchar field.
How do I create a view in db2?
What is dbrm? When it will be created?
What is the use of db2 optimizer?
How is the value function used?
