| Subject | Table structure for efficient storage |
|---|---|
| Author | Daniel L. Miller |
| Post date | 2010-06-16T15:50:59Z |
Having just read the thread on CHAR vs SMALLINT for storing a single byte -
Does the order/sequence of columns in a table make a difference in
storage? I.e., is a table of CHAR(1), CHAR(1), CHAR(1), CHAR(1),
SMALLINT, VARCHAR(50) stored differently than CHAR(1), SMALLINT,
CHAR(1), VARCHAR(50), CHAR(1), CHAR(1)?
--
Daniel
Does the order/sequence of columns in a table make a difference in
storage? I.e., is a table of CHAR(1), CHAR(1), CHAR(1), CHAR(1),
SMALLINT, VARCHAR(50) stored differently than CHAR(1), SMALLINT,
CHAR(1), VARCHAR(50), CHAR(1), CHAR(1)?
--
Daniel