primary ID trick: speed/disk space?
From: Stephen J. Fromm <stephen.fromm_at_verizon.net>
Date: 28 Apr 2003 07:32:44 -0700
Message-ID: <b4cc5e7c.0304280632.14bdeb6f_at_posting.google.com>
Suppose I have a table with a "naturally occuring" key. Does the "primary key integer ID trick" add anything in terms of increasing speed and decreasing disk space? (Possibly yes: foreign key attributes will be an integer. Possibly no: maybe most RDMS's use some kind of pointers for fk constraints anyway.)
Date: 28 Apr 2003 07:32:44 -0700
Message-ID: <b4cc5e7c.0304280632.14bdeb6f_at_posting.google.com>
Suppose I have a table with a "naturally occuring" key. Does the "primary key integer ID trick" add anything in terms of increasing speed and decreasing disk space? (Possibly yes: foreign key attributes will be an integer. Possibly no: maybe most RDMS's use some kind of pointers for fk constraints anyway.)
TIA, sjfromm Received on Mon Apr 28 2003 - 16:32:44 CEST