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
List some fields from sqlca?
In case if at some point of time db2 is down, would that impact the pre-compilation process of a db2-cobol program?
What is db2 look?
How to view db2 table structure?
How do I delete a table in db2?
How many databases can be created inside an instance in db2 ?
What is syscat in db2?
What is the difference between nvl and coalesce?
What is a page in db2?
How to find schema of a table in db2?
What is a collection in db2?
What is an instance database?
Define db2 and its databases?
What is null indicator in db2?
Define sqlca.
