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 load replace in db2?
B37 abend during spufi?
What is view db2?
Define check constraint.
List some fields from sqlca?
How can you validate Sql errors during cursor operation in db2 pgms and where do you code?
How do I add a column to a table in db2?
What is a db2 tablespace?
what is db2 restart?
What is the physical storage length of date data type?
What is difference between isnull and coalesce?
What is page size in db2?
DB2 can implement a join in three ways using a merge join, a nested join or a hybrid join. Explain the differences?
How and when does the db2 enforces the unique key?
Is ibm db2 free?
