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
Is db2 a mainframe database?
When reorg is used?
How can we retrieve the total number of records in RPG & CLLE?
What are bind parameters in db2?
What os does db2 run on?
Explain about rct.
What is dclgen in db2?
Which are the db2 tools to protect integrity of the database?
Explain packages.
Before you give the explain statement, what are the prerogatives?
Describe major components of db2?
Explain the contents that are a part of dclgen.
How do you stop a db2 database in linux?
What is a bind card?
by using cursors , we can access particular records from the table based on some condition, i want to delete those selected records, how can we write a query for this in the program?
