Interested to Buy Any Domain ? << Click Here >> for more details...
Lot of updates have been done on a table due to which
indexes have gone haywire. What do you do?
- 2 Answers
- 5123 Views
- I also Faced
- E-Mail Answers
Answer Posted / mehdee
Yes, Reorg Index and RUNSTATS or Rebuild Index.
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
How can you count the number of rows from a table tab?
What is load utility in db2?
How to get the ddl of a table in db2?
What kind of database is db2?
can all users have the privilage to use the sql statement select * (dml)?
What is dbrm?
How to access db2 tables in mainframe?
Define check constraint.
What is concurrency?
How can you quickly find out the # of rows updated after an update statement?
What are the contents of dclgen?
How to test SQL -911 error while developing COB-DB2 program
DB2 can implement a join in three ways using a merge join, a nested join or a hybrid join. Explain the differences?
How can tablespace be moved to another dasd volume that is allocated for that tablespace?
What is the use of with ur in db2?
