What is reorg in DB2
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / srini
REORG will reorganise the records as per the clustered
Index/index fields,so that the system can access records
easily thru which the access cost will come down
drastically,so its always advisable to run REORG after
every mass inserts/updates/deletes on table.
| Is This Answer Correct ? | 30 Yes | 9 No |
Answer / vivekk ram
when ever a record is deleted, it marks the record to be deleted but the physically it is not deleted in db. So using reorg command is ran, it physically deletes the record from db.
Please correct me, if i'm wrong..
| Is This Answer Correct ? | 0 Yes | 0 No |
What's the maximum number of volumes that can be added to a STOGROUP?
Why select is not preferred in embedded sql programs?
can we update the table by using cursors can anyone post the query?
wht are the restrictions for union ?
What is ALTER ?
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?
What Utility is used to migrate DB2 from one release to the next?
What can the SET option of the Repair Utility accomplish?
What is a clustering index ?
Where is the access path logic created by the DB2 Optimizer stored?
How do you do the EXPLAIN of a dynamic SQL statement?
Hi , I am posting some interview ques . what is the use of cursors ? what is the diff between select and cursor ? bith are used for data retrival .. rite?