Обсуждение: foreign key performance
Hi folks, do foreign keys have any influence on performance (besides slowing down huge inserts) ? do they bring any performance improvement ? thx -- --------------------------------------------------------------------- Enrico Weigelt == metux IT service phone: +49 36207 519931 www: http://www.metux.de/ fax: +49 36207 519932 email: contact@metux.de cellphone: +49 174 7066481 --------------------------------------------------------------------- -- DSL ab 0 Euro. -- statische IP -- UUCP -- Hosting -- Webshops -- ---------------------------------------------------------------------
On Fri, Apr 22, 2005 at 02:06:15AM +0200, Enrico Weigelt wrote: > do foreign keys have any influence on performance (besides slowing > down huge inserts) ? do they bring any performance improvement ? No. They only cause additional tables to be visited to enforce them. -- Alvaro Herrera (<alvherre[@]dcc.uchile.cl>) "Ciencias políticas es la ciencia de entender por qué los políticos actúan como lo hacen" (netfunny.com)