Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / thiru
Yes What Vamsi said is right. But not only it will re-
organise or re arrange the occupied and un occupied space
of the perticular table. By default when we add a new
column to the existing table db2 V9 onwards the REORG is
compulsary. otherwise from any application the table will
not be accessed.
while doing the REORG after New column addition or Bulk
Insert/Load it will rearrange the data internally based on
the indexes available from the table. hence further search
as well as other operations will be faster.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is check constraint in db2?
What is dclgen in db2?
What is a Foreign Key?
Can we insert update delete in view?
How do I delete a table in database?
What is host variable in db2 cobol?
Which isolation level provides maximum concurrency?
What does reorg do in db2?
Explain the function of data manager.
How can the firstname and the lastname from the emp table be concatenated to generate complete names?
How to compare data between two tables in db2?
What is the picture clause of null indicator variable?
Highlight all the advantages that are attached to a package.
What is with ur in db2?
Discuss about db2 bind?
