Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / harish
Reorg is needed whenever indexed columns are updated frequently.
When indexed columns are updated frequently, then the index
for the table has to be created again.
So REORG utility is run which will drop the index and create
the index again for the table.
| Is This Answer Correct ? | 36 Yes | 5 No |
Post New Answer View All Answers
Explain packages.
What is dbrm in db2 database?
i want to maintain uniqueness on pdf without make lf??????????
have 3 tables table1, table2 and table3 which contains employee information. table1 is master table, table2 contains emp details like emp no and so on, table 3 contains emp salary. so if any emp leave company between 25th - 30th of every month it has to get updated in tables. but it is not getting updated. What is the reason.
What is db2 bind process?
What is the purpose of using commit?
What is lock escalation in db2?
What is the use of db2?
What is check constraint. Explain with example.
What is cursor with hold option in db2?
What is the use of value function?
How can the duplicate values be eliminated from db2 select?
Following a db2 update statement, what is the quickest way to compute the total number of updated rows?
What is the difference between using bind () and rebind () methods of naming class?
Highlight all the advantages that are attached to a package.
