Re: non-unique index enforcing pk

I do not have test runs to support my assertion but from the few times I played with the feature I did not see any performance difference so I believe that for most non-unique indexes where few additional columns not part of the PK are included that only a very minor performance difference would exist. For non-unique indexes where no extra columns exist in the index the practical difference should be zero.

IMHO -- Mark D Powell -- Received on Thu Feb 09 2006 - 13:20:23 CST