You do need the foreign keys for integrity and the columns which make
the foreign reference should be indexed as well. My only point is
that bookID is already indexed as the first element in the primary
key, so the additional index on bookID alone is superfluous.
- michael
On Fri, May 22, 2009
Michael Dykman wrote:
> On Fri, May 22, 2009 at 12:26 AM, PJ wrote:
>
>> Michael Dykman wrote:
>>
>>> On Thu, May 21, 2009 at 11:06 PM, PJ wrote:
>>>
>>>
I have a seemingly impossible situation. I cannot insert values into the
tables and I cannot alter or delete the prima
On Fri, May 22, 2009 at 12:26 AM, PJ wrote:
> Michael Dykman wrote:
>> On Thu, May 21, 2009 at 11:06 PM, PJ wrote:
>>
>>> I have a seemingly impossible situation. I cannot insert values into the
>>> tables and I cannot alter or delete the primary key (which should not
>>> exist) or delete the for
Michael Dykman wrote:
> On Thu, May 21, 2009 at 11:06 PM, PJ wrote:
>
>> I have a seemingly impossible situation. I cannot insert values into the
>> tables and I cannot alter or delete the primary key (which should not
>> exist) or delete the foreign keys nor remove the constraint. G search
>>
