Lot of updates have been done on a table due to which
indexes have gone haywire. What do you do?
Answer Posted / s
Reorg Index or Rebuild Index
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
What is collection in db2 bind?
How can you find out the # of rows updated after an update statement?
What is the physical storage length of the data types: date, time, timestamp in the db2 database?
What is db2 and what is the use of db2 optimizer?
What is cursor with hold option in db2?
What is db2 connect?
What is cascading rollback?
What is null indicator in db2?
How do you select a row using indexes in db2?
Explain the function of data manager.
How does coalesce work?
What is multi row fetch in db2?
What is the difference between cursor stability and repeatable read isolation levels?
Explain the function done by data manager?
What are concurrency issues?