Re: Double indexes on one field

2005-10-03 Thread Yannick Warnier
Le lundi 03 octobre 2005 à 16:24 +0200, Bastian Balthazar Bux a écrit : > Yannick Warnier wrote: > > Le lundi 03 octobre 2005 à 12:29 +0200, Martijn Tonies a écrit : > > > >>>Using PhpMyAdmin, I seldom get the warning message: > >>>PRIMARY and INDEX keys should not both be set for column `ID` > >>

Re: Double indexes on one field

2005-10-03 Thread Bastian Balthazar Bux
Yannick Warnier wrote: > Le lundi 03 octobre 2005 à 12:29 +0200, Martijn Tonies a écrit : > >>>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

Re: Double indexes on one field

2005-10-03 Thread Yannick Warnier
Le lundi 03 octobre 2005 à 12:29 +0200, Martijn Tonies a écrit : > > 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 prim

Re: Double indexes on one field

2005-10-03 Thread Alec . Cawley
Yannick Warnier <[EMAIL PROTECTED]> wrote on 03/10/2005 11:18:05: > Hi all, > > 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

Re: Double indexes on one field

2005-10-03 Thread Martijn Tonies
> 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 > queries. > > Is that gonna take twice

Double indexes on one field

2005-10-03 Thread Yannick Warnier
Hi all, 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 queries. Is that gonna take twice the