optimum datatype for primary key column O9i

What is the datatype to be used
for Primary Key columns for most
optimised access given that

• There will be a single column primary key only
• The values will only be integers (but as strings) at least 12 digits (characters) long
• all positions will be occupied (no leading 0's)
• Tables may have upto 1m+ rows
• There will be lot of foriegn key references and master-child access

Please let me have any suggestions

Sanjay Minni
www.planage.com Received on Mon Oct 27 2003 - 09:27:57 CET