Lot of updates have been done on a table due to which
indexes have gone haywire. What do you do?

Answers were Sorted based on User's Feedback



Lot of updates have been done on a table due to which indexes have gone haywire. What do you do?..

Answer / s

Reorg Index or Rebuild Index

Is This Answer Correct ?    2 Yes 0 No

Lot of updates have been done on a table due to which indexes have gone haywire. What do you do?..

Answer / mehdee

Yes, Reorg Index and RUNSTATS or Rebuild Index.

Is This Answer Correct ?    2 Yes 0 No

Post New Answer

More DB2 Interview Questions

What is db2 catalog database?

0 Answers  


pls tell me abt the normalization five types....

2 Answers  


How connect db2 database to datastage?

0 Answers  


what is consistency token

3 Answers  


What are the four lockable units for DB2?

1 Answers  






What's the maximum number of volumes that can be added to a STOGROUP?

1 Answers   IBM,


When do you specify the isolation level?

0 Answers  


Discuss about db2 bind?

0 Answers  


What is an alias?

3 Answers  


What is null indicator in db2?

0 Answers  


What DB2 Catalog column tell you when an index needs table reorganized ?

1 Answers  


What is syscat in db2?

0 Answers  


Categories