In terms of read performance, you won't see much difference splitting
them up within the same table. What will degrade the write performance
is adding of additional indexes since they will need to be updated on
every write. Indexing will obviously speed up search performance
(~read).
I think
> -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 -bb-cc-dd
>
> where a,b,c and d are integers
You want to normalize
