Take the 2-minute tour ×  Consider we have a large set of
statistical data for a record; e.g. 20-30 INT columns. Is it
better to keep the entire set in one table as they all belong to
a record OR creating a another table connected with a one-to-one
relationship.  The advantage of the former is to avoid JOIN and
have a quick access to all statistical data for the
corresponding record.  The advantage of the latter is to keep
the column tidy. The first column is read-intensive, and the
second write-intensive. Of course, I think it has no significant
effect on the performance, as I use InnoDB with row-level
blocking.  In general I want to know if it is practical useful
to separate different sets of data for a single record?
share|improve this question 'Normalized' means first normal form
(1NF) and is a fundamental requirement of the relational model.
'Fully normalized' means 5NF or higher. Your proposed 'one-to-
one relationship' table has a better chance of being in a higher
normal form (possibly even in 6NF) th