Which of the following best describes the major trade-offs for MylSAM fixed-length types vs. variable-length types, respectively?
A.
Fixed-length are slower, but require less disk space, as variable-length are faster, but require more disk space.
B.
Fixed-length are faster and require less disk space, as variable-length are slower and require more disk space.
C.
Fixed-length are faster, but require more disk space, as variable-length are slower, but require less disk space.
D.
Fixed-length are slower and require more disk space, as variable-length are faster and require less disk space.
Explanation:
MYSAM tables, fixed-length columns are best for speed as the info is stored at set positions (multiple of row length) – quicker lookup.
— BUT CHAR columns take up more disk space as the rest of the column is padded out to fill full column width. p344