Re: How to express a b-tree in SQL?
From: KenNorth <knorth_at_my-deja.com>
Date: 2000/02/23
Message-ID: <OTHp4Mmf$GA.276_at_cpmsnbbsa04>#1/1
Date: 2000/02/23
Message-ID: <OTHp4Mmf$GA.276_at_cpmsnbbsa04>#1/1
George,
SQL DBMSs, including Oracle, use b-tree indexes for numbers and character
data. When you run a query, you don't have to worry about manipulating the
tree (for example when INSERTing rows). The DBMS does that for you.
Given that, you can still model a tree structure in SQL. Check out SQL FOR
SMARTIES by Joe Celko (Morgan Kaufmann Publishers).
- Ken North =============================
See you at Java Developer Conference (London, March 13-15, 2000)
www.javadevcon.com
XML One (Austin, March 29-31, 2000) www.xmlconference.com
http://ourworld.compuserve.com/homepages/Ken_North