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's The Percentage Free Space ?
What is a bind card?
What is cobol db2?
Is schema the same as database?
What is the maximum No of rows per page?
What is the difference between cursor stability and repeatable read isolation levels?
What is db2? Explain.
Mention the downsides of page level lock.
In an sql table that is embedded, what is the procedure to retrieve rows that are part of a db2 table?
What is the physical storage length of timestamp data type?
How to run db2 command in windows?
My sql statement select avg(salary) from emp yields inaccurate results. Why?
What are db2 objects?
What is the result of open cursor statement?
How to rename a table in DB2 ?
