Lot of updates have been done on a table due to which
indexes have gone haywire. What do you do?
- 2 Answers
- 4427 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
What is the use of db2?
How can you validate Sql errors during cursor operation in db2 pgms and where do you code?
Explain how can you do the explain of a dynamic sql statement?
Explain the contents that are a part of dclgen.
Suppose pgm A calling Pgm B .Pgm B has some Db2 program. at the time of compilation should plan and package will be created for both A and B or only B? What is the concept?
in my project..TEST is db2 8.1 version In PROD it is 7.1 if i do REORG in TEST.. can I use the same REORG jcl with out modification in PROD region (this is DB2 8.1 )? if not, what modification i need to do in my REORG control card?
What is plan in cobol db2?
What are the full forms of spufi and dclgen and why are they used?
Explain about cursor stability?
How do you pull up a query which was previously saved in qmf?
Why select is not preferred in embedded sql programs?
What is the use of db2 optimizer?
Are views updateable?
what are bind concepts in db2 cobol?
What is sqlca?
