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 a corelated subquerry?

1062

What are db2 tables?

1046

What is the use of dclgen in db2?

1010

What is db2 look?

970

What is reorg?

1069

Is it possible to create an Instance in DB2 using DB2 Control Center ?

1040

How to take backup of table in db2?

1020

Can there be more than one cursor open for any program?

1122

How can you do the explain of a dynamic sql statement?

1011

Is db2 free?

1035

Mention some fields that are a part of sqlca.

969

My sql statement select avg(salary) from emp yields inaccurate results. Why?

1032

How to view db2 table structure?

959

What is deadlock in db2?

1013

In an sql table that is embedded, what is the procedure to retrieve rows that are part of a db2 table?

1048