--- [EMAIL PROTECTED] wrote: > Peter Matulis <[EMAIL PROTECTED]> wrote on 11/15/2005 02:47:56 > PM:
> > but in phpmyadmin I get these types of warning for five > tables: > > > > table 1: > > UNIQUE and INDEX keys should not both be set for column `email` > > > > table 2: > > More than one INDEX key was created for column `mail_id` > > More than one INDEX key was created for column `rid` > > > > table 3: > > More than one INDEX key was created for column `sid` > > > > table 4: > > More than one INDEX key was created for column `preference` > > > > table 5: > > UNIQUE and INDEX keys should not both be set for column `email` > > > > > > Should I be worried about this? > > > > > > Only if you care about the speed of your INSERTs and how much > space your > data+indexes take on your hard drives. If you don't care about > either of > those performance factors, then no, you don't need to worry about > those > warnings. But what are the advantages? If none, why is such a schema proposed? __________________________________________________________ Find your next car at http://autos.yahoo.ca -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]