Follow Our FB Page << >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...

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

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

In BIND, isolation level parameter specifies the duration of page lock and ACQUIRE, RELEASE also do almost the same thing. What is the exact difference between the two? Do they work in conjunction while executing SQL queries and obtaining locks?

8 Answers   Syntel,

What is db2 stogroup?

0 Answers  

What are iseries servers?

0 Answers  

Explain the EXPLAIN statement?

1 Answers  

What is a DB2 bind?

1 Answers   Logica CMG,

What is difference between *omit and *nopass?

1 Answers   IBM, TCS,

Parm value passed is PARM=(10,20). how do code linkage section and how would you add these two passes values and show result in cobol program.

3 Answers   IBM,

DB2 is a A) data base/data communication system B) data base C) RDBMS D) Programming language

4 Answers   Accenture,

What is explain plan in db2?

0 Answers  

Mention the different locking levels that are available in db2.

0 Answers  

What is load replace in db2?

0 Answers  

is it compulsory commitment control in journal?

0 Answers   TCS,