Primary & Index Keys

Worker Joined: Dec 21, 2004 Posts: 116

In most of db tables I got this Warning (translation form italian so it could be not perfect):

Code:

The keys PRIMARY and INDEX couldn't be assigned to se same column "A_COLUMN_NAME"

Is this a problem ? How can I solve it ?

Site Admin/Owner Joined: Aug 27, 2002 Posts: 17088

It doesn't cause a problem other than overhead. You should be able to drop the INDEX and just leave the PRIMARY.

Posted: Mon Sep 05, 2005 3:10 pm

Raven wrote:

You should be able to drop the INDEX and just leave the PRIMARY.

This makes better (less time loading a page) and worst (most time searching in db) speed ?

Posted: Mon Sep 05, 2005 5:34 pm

It shouldn't. Whether the index is a regular or primary, the query should still use it.