Q
Problem solve Get help with specific problems with your technologies, process and projects.

Number or float for primary key?

From a performance point of view, is it recommended to use a number or a float (0 decimal) as primary key?
Many systems use surrogate primary keys whose values are generated by Oracle sequences; these are typically integers. If, however, your table contains a column of type FLOAT that is a candidate primary key, the use of the column as the primary key should not cause any noticeable performance degradation. As always, your best bet is to verify through testing.

Dig Deeper on Oracle database performance problems and tuning

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.

-ADS BY GOOGLE

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide.com

SearchDataCenter

SearchContentManagement

SearchHRSoftware

Close