On 10/11/12 2:07 AM, Vineet Deodhar wrote:
> To give an example, I have tables for storing master records (year
> master, security master, etc.) for which pkid TINYINT is just sufficient.
> These pkid's are used as fk constraints in tables for storing business
> transactions.
> The no. of rows in business transactions tables is in millions.
> Here, I NEED to worry about the storage space occupied by the pkid fields.
IMHO, its not significant to save a byte per field unless there's 30 or
100 of these fields in a single row.
--
john r pierce N 37, W 122
santa cruz ca mid-left coast