to be
indexed as well.
My question is: in terms of read and write performance, is it better to
split them up into 4 indexed columns of integer instead or to keep them
in one indexed column of char?
If they should be kept in one column, what is the quickest way to
search? To use a regular
-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 your
, is it better
to split them up into 4 indexed columns of integer instead or to keep
them in one indexed column of char?
If they should be kept in one column, what is the quickest way to
search? To use a regular expression?
- Mathias
--
Brent Baisley
Systems Architect
Landover Associates, Inc