Interested to Buy Any Domain ? << Click Here >> for more details...
What are leaf pages?
- 3 Answers
- 8847 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 |
i want to know how the commit option works,how it save the changes? it will update the database or what ? where we can see these saved changes?
What is temporal table in db2?
What is cloudant database?
insert into tablename a column1, column2 select column1, column2 from tablename b i am getting abend -104..can any one help?
quary for 1> fetch last record 2> fetch in reverse order 3> fetch last 5 row 4> fetch second last record (their is no primary key) i think concept of count can be use for this in 4th
How to resolve deadlock issue
What is buffrpool? Where we use it ?
What is cobol db2?
Explain in brief how does db2 determine what lock-size to use?
What is JOIN and different types of JOIN.
What is the physical storage length of date data type?
What is PRIME TABLE and what are the uses of it
COBOL 
