Interested to Buy Any Domain ? << Click Here >> for more details...
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 the role of the data page in the db2 database?
What is the difference between bind and rebind in db2?
What is a db2 collection?
What type of database is db2?
How do I delete a table in database?
How is a typical db2 batch pgm executed?
How to view db2 table structure?
What is declare cursor?
What is rct?
is it compulsory commitment control in journal?
Explain about dbrm.
What is the physical storage length of the data types: date, time, timestamp in the db2 database?
B37 abend during spufi?
What is dclgen in db2?
What is the purpose of using commit?
