Home » RDBMS Server » Server Administration » sequence PK vs. 2 Char fields PK
sequence PK vs. 2 Char fields PK [message #369419] Tue, 19 September 2000 08:27
Chad Bradley
Messages: 2
Registered: September 2000
Junior Member
In speaking to one of the Oracle Data Modelers at my company, she is trying to make me believe that using a sequence PK is slower than using 2 Char fields for a PK - in every way, insert/update/delete records and for joining.

To me, that makes absolutely zero sense from a math standpoint. How can 2 string comparisons possibly be faster than a single numeric comparison.

Can someone please provide online PROOF to show to her that she is wrong?
Previous Topic: form 6/IE
Next Topic: sequence PK vs. 2 Char fields PK
Goto Forum:
  


Current Time: Thu Apr 18 23:13:51 CDT 2024