Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / 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 |
Post New Answer View All Answers
Which are the db2 tools to protect integrity of the database?
What is buffer pool in the db2 database?
Explain db2.
How do I change the column size in db2?
What are the contents of dclgen?
Which component is used to execute the sql statements?
What are catalog tables in db2?
Is db2 a programming language?
What is the picture clause of null indicator variable?
Explain package in db2 and its advantages?
File not opened because library is *PROD and debug is UPDPROD(*NO). ? what may be the reason? how to solve it..?
What is bind package and plan in db2?
What action db2 takes when a program aborts in the middle of a transaction?
How and when does the db2 enforces the unique key?
What is the difference between "db2ilist" and "db2 get instance" commands in DB2 Database Server?
