Toreador (6/27/2012)
vk-kirov (6/26/2012)
I can create an index by means of a unique constraintThat's exactly the basis on which I answered "None unless the rest of the statement creates one", which I therefore believe should be the correct answer. Particularly given that the previous "index defaults" question was about the possibility of a Unique constraint appearing later in the statement!
In what sense does that index support the foreign key constraint?
The question asks specifically about creation of an index to support the foreign key constraint.
Tom