Problem solve
Get help with specific problems with your technologies, process and projects.
Number or float for 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
-
![]()
Improve querying with Redshift, MySQL database replication options
By: Ofir Nachmani
-
![]()
SQL CONSTRAINT clauses: FOREIGN KEY, CHECK and DEFAULT
By: Robert Sheldon
-
![]()
SQL CONSTRAINT clauses: PRIMARY KEY and UNIQUE
By: Robert Sheldon
-
![]()
Set database constraints using SQL Server Management Studio Table Designer
By: Robert Sheldon
