Re: optimum datatype for primary key column O9i
Date: 28 Oct 2003 22:28:17 -0800
Message-ID: <4fe109d.0310282228.7358f8c4_at_posting.google.com>
> make PK columns NUMBER whenever possible -- with our without a maximum
> precision
>
> always declare the FK column(s) with the exact same datatype and precision
> as the referenced PK column(s)
>
> assign the PK value with an Oracle SEQUENCE object
> Mark C. Stock
> www.enquery.com
Thanks,
in an attempt to optimise
Q. Is the storage pattern same if the number is shorter say NUMBER(10,2)
except off course the saving of say one byte per value
specially in indexes (I can even go shorter if required)
and ...
Q is there any overheads in joins when using NUMBER datatype
The highest use of the primary key will be in Joins
and the implicit internal index accesses and comparisions
in joins.
There will hardly be any other use of the primary key values
Now as I need only
I will declare as NUMBER(12,0)
Regards
Sanjay Minni
Received on Wed Oct 29 2003 - 07:28:17 CET