Home » RDBMS Server » Server Administration » sequence PK vs. 2 Char fields PK
sequence PK vs. 2 Char fields PK [message #369420] Tue, 19 September 2000 08:28
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: sequence PK vs. 2 Char fields PK
Next Topic: db_block_size & installation
Goto Forum:
  


Current Time: Fri Mar 29 00:01:01 CDT 2024