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

Can you use max on a char column?

1077

For a db2 column that is being defined as decimal (11, 2), discuss the cobol picture clause.

1094

If the cursor is kept open followed the issuing of commit, what is the procedure to leave the cursor that way?

1124

What does db2 mean?

992

What is scrollable cursor in db2?

1042

What happens in bind step in a db2 program?

958

Where can you declare a cursor in a cobol-db2 program?

1056

What is cursor in dbms?

1048

What are the different types of base tables?

1073

What is table space in db2?

1006

What do you mean by storage group (stogroup)?

1024

What is cursor with hold option in db2?

1053

What is a db2 table?

990

Mention the definition of cobol in varchar field.

1227

What is image copy in db2?

994