Answer Posted / mehdee
About the above question. We create INDEX when we create a
DB2 table, but Leaf pages are created by DB2 as this DB2
table being accessed and it keeps going on. That is why
DBADM use the SYSIBM.SYSINDEXES table and check on the
column LEAFDIST to see for example if it is greater than
500, then they run the REORG job then RUSTATS to bring down
the Leaf pages distribution to less then 500 to improve
access performance.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is role in db2?
Highlight all the advantages that are attached to a package.
What is a buffer in memory?
What is page size in db2?
How do I add a column to a table in db2?
What is an instance in db2?
What is database reorganization?
What are catalog tables in db2?
Where can you declare a cursor in a cobol-db2 program?
What is explain plan in db2?
What is a cursor in programming?
What is table space in db2?
What is the use of dclgen in db2?
What are the various isolation levels possible?
What do you mean by commit and rollback?
