Lot of updates have been done on a table due to which indexes have gone haywir

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

Question Posted / guest

2 Answers
5140 Views
I also Faced
E-Mail Answers

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

Explain about rct in db2?

0 Answers

What is the use of reorg in db2?

0 Answers

what is the Foreign key? explain?

2 Answers

Hi this is sures. i need to practice the ibm mainframes.could u telme how can i get userid from IBM.how much cost they will collect for one user id.can send me the details please.thanq

2 Answers

How do you select a row using indexes in db2?

0 Answers

What is view db2?

0 Answers

Say CUST Table contains records like: CUSTNO CUSTNAME CUSTLOC 100 ABC SSS 200 XYZ 300 PQR 400 MNO WWW 500 CVV ------------- ------------- Now write a query to retrieve all records with CUSTLOC no data.

3 Answers IBM,

What is ibm db2 connect?

0 Answers

What is correlation names?

1 Answers

what needs to be done if a table is in copy pending / check pending status?

5 Answers Xansa,

ther r 2 tables OTTABLE & SALTABLE, add the otamt from OTTABLE to empsal of SALTABLE if eid is matched else add the unmatched from OTTABLE to SALTABLE

0 Answers

Is ibm db2 open source?

0 Answers

For more DB2 Interview Questions Click Here