Lot of updates have been done on a table due to which
indexes have gone haywire. What do you do?
- 2 Answers
- 4231 Views
- I also Faced
- E-Mail Answers
Answer Posted / mehdee
Yes, Reorg Index and RUNSTATS or Rebuild Index.
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
What is a bind card?
What are host variables in db2?
What are the rules for db2 programming?
Give a brief description of db2 isolation levels?
How to restart a DB2 program?
Why select is not preferred in embedded sql programs?
what are bind concepts in db2 cobol?
What is null in db2?
How will you return the number of records in table?
What's The Error Code For Unique Index Voilation?
Can there be more than one cursor open for any program?
What is difference between alias and synonym in db2?
Explain dclgen.
What is package in db2 mainframe?
What action db2 takes when a program aborts in the middle of a transaction?
