Interested to Buy Any Domain ? << Click Here >> for more details...
What are leaf pages?
- 3 Answers
- 8717 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 |
How to resolve -818 sql code in DB2?
Mention the definition of cobol in varchar field.
How would you move a tablespace (using STOGROUP) to a different DASD volume allocated to that tablespace?
If we have 100 records in the PF, we deleted all the records then what is the Size of the PF?
Which catalog tables contain authorization information?
what is the maximum number of tables that can be joined ?
Which components manage deadlocks in db2?
How do you declare a host variable (in COBOL) for an attribute named emp-name of type VARCHAR(25) ?
in my table i will update only 100 record among 1000 records i need to display recently updated record'.....can u tell me where those records are stored how can i display those records...?if there is any sql query pls let me know....?
how to copy the host variables from ps file into cobol program other than include statement
Where do you specify them?
How to get Top 10 Salaries from a Table
COBOL 
