Icon View Thread

The following is the text of the current message along with any replies.
Messages 1 to 2 of 2 total
Thread Constraints & indexes
Sun, Oct 26 2008 1:02 PMPermanent Link

Walter Van Belle
When creating primary keys and foreign keys, constraint owned indexes are created
automatically.
Should one keep or drop indexes with same fields that existed before creating the constraint?
Mon, Oct 27 2008 11:46 AMPermanent Link

Fernando Dias

Team Elevate Team Elevate

Walter,

You must also take in account the collation, case and accent
sensitiveness of those indexes. If all this is the same, then you should
drop the previously created indexes.

--
Fernando Dias
[Team Elevate]
Image