FAQ Primary Keys
From: William Curtis <wcurtis_at_mindspring.com>
Date: 1995/04/14
Message-ID: <wcurtis.2.0009D176_at_mindspring.com>#1/1
Oracle DBA
Received on Fri Apr 14 1995 - 00:00:00 CEST
Date: 1995/04/14
Message-ID: <wcurtis.2.0009D176_at_mindspring.com>#1/1
Is there a significant performance difference in using a varchar2(10) or a number(10) for a primary key? The tables will have 5 - 15 million rows in them. I have heard discussions for both datatypes. I would be interested if anyone has any benchmarks on this subject.
Environment: Oracle 7.1.3 / Sun Solaris 2.3
You may e-mail me information : wcurtis_at_mindspring.com
Thanks in advance
William
William Curtis, Jr. Have Oracle...... wcurtis_at_mindspring.com Will Travel.....Keane, Inc
Oracle DBA
ORA-03113 end-of-file on communication channel
Received on Fri Apr 14 1995 - 00:00:00 CEST