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 the meaning concurrency in the db2 database?
Which is faster delete or truncate?
Hi, i would like to start a new carrier in DB2 DBA.Which and what all step should i have to take..?
How can you do the explain of a dynamic sql statement?
Before you give the explain statement, what are the prerogatives?
What is check constraint in db2?
What is catalog database in db2?
What is the physical storage length of date data type?
What types of tables are there in the db2 database?
What is package in cobol db2?
What are the benefits of using the db2 database?
What is a dbrm in db2?
How many databases can be created inside an instance in db2 ?
What is the function of logging in the db2 database?
What is db2? Explain.
