Home -> Usenet -> comp.databases.oracle -> Re: using big primary keys v/s small primary keys

Re: using big primary keys v/s small primary keys

From: godmann <allanwtham_at_yahoo.com>
Date: 10 Sep 2001 19:47:03 -0700
Message-ID: <95cd51c.0109101847.1f6eacf9_at_posting.google.com> 







Hi there,



  My mistake. Read the below:



Within a B*tree index, index blocks are either branch blocks, the upper blocks 
within the B*tree index, or leaf blocks, the lowest level index blocks. Branch 
blocks contain index data that point to lower level index blocks. Leaf blocks 
contain every indexed data value and a corresponding ROWID used to locate the 
actual row.



So leaf index format is made of 



    
  
  1.   Index Entry Header
  
  2.   Key Column length
  
  3.   Key Column value
  
  4.   ROWID. 





  Note the branch doesn't have ROWID.



Allan W. Tham


DBA

Received on Tue Sep 11 2001 - 04:47:03 CEST












Original text of this message