What are leaf pages?

Answers were Sorted based on User's Feedback



What are leaf pages?..

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

What are leaf pages?..

Answer / rbs

Hi S,
Above, u defined the INDEX. Is index and Leaf Pages are
same?

Is This Answer Correct ?    0 Yes 0 No

What are leaf pages?..

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

Post New Answer

More DB2 Interview Questions

What is -904 sql code? How to resolve it?

3 Answers  


Name some fields from SQLCA.

2 Answers  


is it compulsory commitment control in journal?

0 Answers   TCS,


if one db2 pgm calls another db2 pgm. how many plans do we need. what r the steps involved..

4 Answers   IBM,


Where would you find information about the type of database authority held by the user?

2 Answers  






Highlight all the advantages that are attached to a package.

0 Answers  


Can we declare DB2 HOST variable in COBOL COPY book?

2 Answers  


How do we specify index to include or not during bind process.

0 Answers   Satyam,


4. A DB2 application is bound with uncommitted Read isolation level.It issues a request that retrieves 20 rows out of 200000 in the table. Which of the following descrbes the rows that are locked as a result of this request? a. None of the rows are locked. B.The retrieved rows are locked. C.The last row of the result set is locked. D.The rows not previously updated by another application are locked.

3 Answers   Wipro,


how can we retrieve the 100 records of the file ?

2 Answers   IBM,


what is different three logs in DB2?

1 Answers   Syntel,


How to resolve -818 sql code in DB2?

2 Answers   Cap Gemini,


Categories