Re: all foreign key should have index?
From: -CELKO- <jcelko212_at_earthlink.net>
Date: 30 Jan 2006 21:57:39 -0800
Message-ID: <1138687059.234890.22280_at_g47g2000cwa.googlegroups.com>
Date: 30 Jan 2006 21:57:39 -0800
Message-ID: <1138687059.234890.22280_at_g47g2000cwa.googlegroups.com>
>> Is it necessary that all foreign key should have index? <<
No. But better SQL products construct a "PK=FK" index under the covers for you. Received on Tue Jan 31 2006 - 06:57:39 CET