Interested to Buy Any Domain ? << Click Here >> for more details...
What are leaf pages?
- 3 Answers
- 8968 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / s
Leaf pages points to data pages. It stores the key value
and the RIDS associated with the values. RIDS are pointers
to the data rows.
| Is This Answer Correct ? | 2 Yes | 0 No |
Answer / rbs
Hi S,
Above, u defined the INDEX. Is index and Leaf Pages are
same?
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / 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 |
what is the differences between spufi and qmf and which is better?
4 Answers Accenture, Cap Gemini,
What are the two types of logging in the db2 database? Explain them.
What's the difference between DB2 active log and archive log? Thanks a lot...
what is the name of the default db2 catalog database?
what types of copies can be made with the COPY Utility ?
What does db2 plan contain?
How to take backup of table in db2?
What is DCLGEN ?
What is phantom read in db2?
What is copy pending and check pending in db2?
Describe major components of db2?
What's the maximum number of volumes that can be added to a STOGROUP?
COBOL 
