Linked Lists in Oracle Tables
From: KevY <google_at_kevyale.com>
Date: 10 Apr 2003 13:19:18 -0700
Message-ID: <2c436769.0304101219.5d12c677_at_posting.google.com>
Date: 10 Apr 2003 13:19:18 -0700
Message-ID: <2c436769.0304101219.5d12c677_at_posting.google.com>
If I'm storing a hierrachy in an Oracle table, is there any benefit in
making the records "doubly-linked" (i.e. each having a "parent" and a
"child" reference) rather than simply having a "singly-linked" list
(i.e. just a "parent" reference)?
Is that really as good as it gets? Doesn't Oracle efficientize this somehow? Is there no real concept of "pointers" that can take you directly to another referenced record, without having to check all records against the key to find the match? Received on Thu Apr 10 2003 - 22:19:18 CEST