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
What is the picture clause of null indicator variable?
How can you find out the # of rows updated after an update statement?
What is concurrency?
Is db2 free?
How to connect to db2 database from windows command line?
What is a system catalog table in db2?
Define buffer pool.
Hi, i would like to start a new carrier in DB2 DBA.Which and what all step should i have to take..?
What types of tables are there in the db2 database?
What is dclgen (declaration generator)?
Which isolation level provides highest data integrity?
Can we delete records from view?
What is dbrm? When it will be created?
Which command is used to remove all rows from a table?
What does a deadlock mean in DB2?
