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
How do you select a row using indexes in db2?
what is db2 restart?
What is role in db2?
What does reorg do in db2?
What are union and union all?
Explain about mirror activator disk mirroring?
How do you find the maximum value in a column in db2?
What is the difference between bind and rebind in db2?
What os does db2 run on?
What is the maximum number of columns in a db2 table?
What is the difference between db2 and oracle?
Explain about dbrm.
Why cursor is used in db2?
Explain packages.
What is null value in db2?
