Number or float for primary key?

Published: 18 May 2004

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

SearchDataManagement

Instaclustr CTO on open source database as a service

Ben Bromhead, co-founder and CTO of Instaclustr, provides insight into the state of the open source database-as-a-service market ...

Percona users detail open source database challenges

Speakers from Shopify and LinkedIn outline open source database cloud and security challenges and best practices at the Percona ...

Grafana 7.0 from Grafana Labs expands data visualization

Distributed tracing data joins log metrics in Grafana 7.0 release, providing users with more ways to connect, observe and ...

SearchBusinessAnalytics

HR use case shows value of Oracle Analytics Cloud

A use case presented during Oracle Analytics' virtual user conference shows how the vendor's platform can bring value to an ...

Sisense helps Soft Stuff pivot business during pandemic

Soft Stuff, a wholesale distributor of gourmet foods, was able to change its business strategy amid the COVID-19 crisis, thanks ...

4 features of great data visualization and storytelling

Data visualization and storytelling go hand in hand when it comes to explaining data. Here are four ways to make sure you build ...

SearchSAP

SAP S/4HANA Cloud 2005 focuses on supply chain

The latest version of S/4HANA Cloud has functions for supply chain, finance and SuccessFactors integration that will likely ...

SAP HANA database turns 10

In this Q&A, SAP's Gerrit Kazmaier discusses how the SAP HANA database has become the platform to enable the intelligent ...

SAP App Center a bridge between ISVs and customers

SAP customers and ISV application developers describe how they use the SAP App Center to find and deploy useful, integrated and ...

SearchSQLServer

SQL Server database design best practices and tips for DBAs

Good database design is a must to meet processing needs in SQL Server systems. In a webinar, consultant Koen Verbeeck offered ...

SQL Server in Azure database choices and what they offer users

SQL Server databases can be moved to the Azure cloud in several different ways. Here's what you'll get from each of the options ...

Using a LEFT OUTER JOIN vs. RIGHT OUTER JOIN in SQL

In this book excerpt, you'll learn LEFT OUTER JOIN vs. RIGHT OUTER JOIN techniques and find various examples for creating SQL ...

TheServerSide.com

The Ben Franklin Effect and software developer career advice

Are you a new programmer in need of a quick and simple way to blend in with your team? Here's some career advice from none other ...

Oracle's Project Leyden uses static images to ease Java pain

Oracle's new Project Leyden introduces static images to help ease long-standing Java language shortcomings such as slow startup ...

Oracle's GraalVM finds its place in Java app ecosystem

Oracle's GraalVM, a universal virtual machine that runs apps written in Java and other languages, has carved out a spot in the ...

SearchDataCenter

Microsoft supercomputer looks to create AI models in Azure

Microsoft has expanded its AI initiative up to the supercomputer market, unveiling a system focused on helping users build large ...

Data center liquid cooling market heats up

As organizations increase server rack density, more C-level execs investigate liquid cooling technology. Industry experts see ...

Considerations for SIEM logging software and storage

SIEM systems aggregate a lot of data across all types of infrastructure. For regular audits, admins should address notification ...

SearchContentManagement

Adobe Experience Manager buoys U.S. census during pandemic

The first U.S. Census digital experience was launched in time for the pandemic, and now Adobe looks to parlay the success into ...

Microsoft buys Softomotive to boost Power Platform RPA

Microsoft's acquisition of Softomotive gives Power Automate users a low-code RPA system to build bots for Windows-based tasks.

Get to know key features of content services platforms

A content services platform is more than a database -- it is an intelligent information engine. Organizations should be familiar ...

SearchHRSoftware

Zuckerberg lists benefits, drawbacks of remote work

After the pandemic, Facebook co-founder and CEO Mark Zuckerberg believes his firm will have more employees who work remotely, ...

HR technologies solidify HR employee experience near and far

Culture, physical and virtual workspaces, and policies play key roles in fostering worker loyalty and engagement -- with the help...

AI in HR recruitment targets high-demand technology talent

As demand for technology talent persists, even during pandemic times, AI, chatbots and machine learning play an increasingly ...

Dig Deeper on Oracle database performance problems and tuning

Improve querying with Redshift, MySQL database replication options

SQL CONSTRAINT clauses: PRIMARY KEY and UNIQUE

Set database constraints using SQL Server Management Studio Table Designer

Enforcing data integrity in a SQL Server database

Start the conversation

0 comments

Register

Login

Forgot your password?

Your password has been sent to:

Please create a username to comment.