Re: optimum datatype for primary key column O9i
From: Sanjay Minni <sminni_SPAM_DIVERTER_at_planage.com>
Date: 27 Oct 2003 18:23:08 -0800
Message-ID: <4fe109d.0310271823.58b3b2c8_at_posting.google.com>
Date: 27 Oct 2003 18:23:08 -0800
Message-ID: <4fe109d.0310271823.58b3b2c8_at_posting.google.com>
What I meant was that specifically to Oracle 8i/9i,
internal data storage methods and data & index structures
what will be the optimum datatype to be used
[for 12 digit key lengths] to make best use
of space [data & index] and speed of access [joins etc].
The effect will cascade as most of the primary key columns
will be duplicated as foriegn keys in other tables
and invariably large joins will be used
Sanjay Minni