On 2012-10-11, Vineet Deodhar <vineet(dot)deodhar(at)gmail(dot)com> 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.
with disk at about 50c/Gigabyte why is it you need to worry?
--
⚂⚃ 100% natural