Yes, Reorg Index and RUNSTATS or Rebuild Index.

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

Question Posted / mehdee

Answer Posted / mehdee

Is This Answer Correct ?

2 Yes

0 No

Please Help Members By Posting Answers For Below Questions

What is ibm db2 client?

1008

How and when does the db2 enforces the unique key?

1143

What kind of database is db2?

1087

Why do we bind in db2?

1276

What is the maximum size of varchar data type in db2?

1178

Mention the downsides of page level lock.

1220

How to find the number of rows in db2 tables?

1133

What is temporal table in db2?

1102

Is db2 relational database?

1047

How can we retrieve the total number of records in RPG & CLLE?

710

What is phantom read in db2?

1227

What are the contents of a dclmgen?

1177

Mention data types used in db2 ?

1204

What is dbrm? When it will be created?

1091

Name the various locking levels available?

1137