Re: Primary Key of a table
From: Jay Mehta <jvmehta_at_mra.ffx.mobil.com>
Date: 1996/03/28
Message-ID: <4jebm3$5p_at_dlsn31.dal.mobil.com>#1/1
Date: 1996/03/28
Message-ID: <4jebm3$5p_at_dlsn31.dal.mobil.com>#1/1
One of the consultant I worked with recommends only numeric primary key. Numeric primary keys may be the most efficient. Numeric column uses 2 bytes to 21 bytes max to store a number, depending on the value and that may be less compared to character or other datatypes. Compact size of primary key may result in improved performance.
Jay Mehta
DBA
Mobil Oil
Received on Thu Mar 28 1996 - 00:00:00 CET