Re: Table clustering idea

Jim C. Nasby wrote:
> On Sun, Jun 25, 2006 at 08:04:18PM -0400, Luke Lonergan wrote:
>   
>> Other DBMS have index organized tables that can use either hash or btree
>> organizations, both of which have their uses.  We are planning to
>> implement btree organized tables sometime - anyone else interested in
>> this idea?
>>     
>
> I'm curious how you'll do it, as I was once told that actually trying to
> store heap data in a btree structure would be a non-starter (don't
> remember why).
>   
Ingres is now open source - they have clustering on btree/isam/hash 
(it's called "modify table xx to btree on col1,col2")

Regards,
Kim