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 -904 sql code? How to resolve it?
Name some fields from SQLCA.
is it compulsory commitment control in journal?
if one db2 pgm calls another db2 pgm. how many plans do we need. what r the steps involved..
Where would you find information about the type of database authority held by the user?
Highlight all the advantages that are attached to a package.
Can we declare DB2 HOST variable in COBOL COPY book?
How do we specify index to include or not during bind process.
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.
how can we retrieve the 100 records of the file ?
what is different three logs in DB2?
How to resolve -818 sql code in DB2?