While designing a database for a very large organization, where the data can reach terabytes and where records need to be kept for years in the database, what type of ID field should be used?
I mean, say a table has a field called "TransactionID" which is of type LONG INTEGER. If this is a primary key, or is included in a composite key, to uniquely identify records, how long can it reach? In this situation, when records are not deleted but remain in the database for years, for further reference, in this case what should be the datatype of the "TransactionID" field?
Dig Deeper on Oracle database design and architecture
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.