Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> comp.databases.theory -> Re: Stupid Database Tricks

Re: Stupid Database Tricks

From: Laconic2 <laconic2_at_comcast.net>
Date: Sat, 19 Jun 2004 09:19:34 -0400
Message-ID: <3eWdnVWUzoqXoEndRVn-hg@comcast.com> 





    
  
  1.   All of the tables are exactly 80 bytes wide.  It's for historical
reasons...

  
  2.   For efficiency, all of the sets we work with are maintained by doubly
linked lists.  See those two columns called NEXT_ID and PRIOR_ID?  That's
what they do.  The old CODASYL DBMS did that for us automatically,  but when
we moved to relational we found we had to do it ourselves!



Received on Sat Jun 19 2004 - 08:19:34 CDT












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US