On Thu, Aug 26, 2004 at 12:04:48PM -0700, J. Andrew Rogers wrote: > The major caveat to having tables of this type is that you can only have > a primary key index. No other indexes are possible because the "heap" > constantly undergoes local reorganizations if you have a lot of write > traffic, the same kind of reorganization you would normally expect in a > BTree index.
This isn't true, at least in 9i. You can create whatever indexes you want on an index-organized table. I believe that the index stores the PK value instead of the ROWID. -- Jim C. Nasby, Database Consultant [EMAIL PROTECTED] Give your computer some brain candy! www.distributed.net Team #1828 Windows: "Where do you want to go today?" Linux: "Where do you want to go tomorrow?" FreeBSD: "Are you guys coming, or what?" ---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]