Sequential Keys & performance
From: Hank Burns <hburns_at_Vance.Net>
Date: 1996/08/19
Message-ID: <32194BA0.436C_at_Vance.Net>#1/1
Date: 1996/08/19
Message-ID: <32194BA0.436C_at_Vance.Net>#1/1
I have a question about the insertion of rows into a table using
sequential numbers. It has been suggested by our DBA's that the use of
sequential numbers as a primary key will perform poorly and we should
write a function that would distribute the keys randomly. Is this really
necessary? If it is, why do sequence objects provide for sequential
number assignment?
Thanks, Hank
Received on Mon Aug 19 1996 - 00:00:00 CEST