> -----Original Message----- > From: Mathias [mailto:[EMAIL PROTECTED] > Sent: den 8 juli 2005 11:50 > To: mysql@lists.mysql.com > Subject: To split or not to split columns > > I have an index char column in the format aaaa-bbbbbb-cc-dd > > where a,b,c and d are integers
You want to normalize your database to least 1NF. Read <http://dev.mysql.com/tech-resources/articles/intro-to-normalization.html> if you are unsure of what 1NF means. Applying indexes on the resulting scheme may improve your performance significantly. /Thomas -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
