Results 1 to 3 of 3
  1. #1
    Join Date
    Jun 2007
    Posts
    197

    Smile Unanswered: duplicate unique key on same column

    Hi,

    in the table structure there is duplicate unique key on same column

    as well as key also for that column

    UNIQUE KEY `FormID` (`FormID`),
    UNIQUE KEY `FormID_2` (`FormID`),
    KEY `formtracker_formid_index` (`FormID`),

    I think duplicate UNIQUE KEY l make effect on insert performance

    Is Index Key on column required as UNIQUE KEY is already applied?
    will dropping one of the UNIQUE KEY make insert faster?
    Last edited by ankur02018; 02-08-10 at 07:46.

  2. #2
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    Quote Originally Posted by ankur02018 View Post
    I think duplicate UNIQUE KEY l make effect on insert performance
    yes, get rid of the duplicate

    Quote Originally Posted by ankur02018 View Post
    Is Index Key on column required as UNIQUE KEY is already applied?
    no, so get rid of this, too
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

  3. #3
    Join Date
    Jun 2007
    Posts
    197

    Smile

    Quote Originally Posted by r937 View Post
    yes, get rid of the duplicate

    no, so get rid of this, too
    Thanks for good suggestion

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •