Answer Posted / aasif
A common maintenance task performed by database
administrators is the reorganization of data in tables and
indexes, called "reorg." Table reorganization is used to
defragment a table, reclaim free space, and eliminate
overflow rows in order to improve data access performance.
Optionally it can be used to reorder data in the order of a
particular index, to optimize queries that use that index.
Is This Answer Correct ? | 10 Yes | 1 No |
Post New Answer View All Answers
What is the advantage in De-normalizing tables in DB2?
How do I add a column to a table in db2?
How does cobol compile db2 program?
Hi Everyone... Under the Logical files, when am working on multiple rec format logical file, I have joined two pf's using the multiple record format logical file concept, but when i run queried the LF only the first mentioned pf records are reflecting and I am not able to see any of the field records specified under the second pf. Kindly let me know whats the reason behind this. Below is the str of LF., R rec PFILE(LOGICAA) CUSTNO CUSTNAME BILL K CUSTNO R rec1 PFILE(LOGICAA1) CUSTNO ADD K CUSTNO .....
What is db2 bind?
What is the use of dclgen in db2?
What is universal database?
What is scrollable cursor in db2?
What is the clustering index in the db2 database?
What is host variable in db2 cobol?
What is coalesce in db2?
What is the difference between dbm cfg and db cfg file in db2 ?
Hello All, We have requirment to Replace BMC Db2 Load product thru CA FAST LOADPlus product. Do anyone have JCL to for FAST LOADPLUS and what all are thing need to take in consideration.
If I have a view which is a join of two or more tables, can this view be updateable?
What is access path in db2?