Joins and links
От | Ansley, Michael |
---|---|
Тема | Joins and links |
Дата | |
Msg-id | 1BF7C7482189D211B03F00805F8527F70ECFF8@S-NATH-EXCH2 обсуждение исходный текст |
Список | pgsql-general |
>> 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 about this recently in a warehousing (again, sic) magazine, and I think it's a great idea. I think that in certain areas, the performance benefits would make it well worth while, although obviously you have to be careful in design. It simply removes the need for the second scan because the keys are used to link the records, and this is managed totally by the dbms. Sorry about the previous unfinished message. Ctrl-Enter does a send on my mail client, now I know. MikeA.
В списке pgsql-general по дате отправления: