What are leaf pages?
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 image copy in db2?
Can any one tell me about Restart logic in DB2.
Can All Users Have The Privilege To Use The SQL Statement Select (DML)?
What techniques will be used to avoid deadlock??
What is a system catalog table in db2?
How do run the JCL which has 25 steps by skipping the following steps 5, 10,15 and 25 without using COND statement
If I have 5 Queries in a DB2 Cobol program , while precompiling how many DBRMs will get created and How many Plans and Packages will get created while Bind Process?
What is null value in db2?
What is sqlca?
Name some fields from SQLCA.
What is consistency token in db2?
What is a trigger in the db2 database?