> Using PhpMyAdmin, I seldom get the warning message:
> PRIMARY and INDEX keys should not both be set for column `ID`
> I understand its meaning, but I was wondering to what extent having a
> field indexed AND being a primary key might slow down/speed up my
> Is that gonna take twice the time if I am searching on the ID field,
> just because there are two indexes?
> I'd like to have a rough idea of how serioulsy I need to avoid these.
Creating a PRIMARY KEY will automatically create an index.
Why would you create a second index for that field?
Database Workbench - tool for InterBase, Firebird, MySQL, Oracle & MS SQL
Database development questions? Check the forum!