RE: pgsql-general-digest V1 #376

>>  Hmm a very interesing theoretical topic...
>>  Wouldnt make sense to tie this in with the implementation of a Foriegn
Key?
>>  So when the foriegn key is defined you create anoter index that stores
all
>>  the relevant child to parent relationships and can be used to speed up
that
>>  access since it obviously will be a primary access route (else thay
wouldnt
>>  have defined it).  I would think it could be used then to check the
Foreign
>>  Key integrity and used to help maintain/construct clustered tables...
I read an interesting article a little while back about 'join indexes'.  It
was in
a warehousing (again, sic) magazine, and the principle was exactly this.  I
think
it's a great idea, although obviously performance becomes an issue.
However, for the