Re: Are varchar primary keys less efficient than autonumbers?
Composite primary keys are at least better than some varchar. So you could safely drop the varchar option.
Whether composite key is better than an artifial auto-increment key is not clear to me. There is some controversy about this, e.g.
http://www.webdeveloper.com/forum/archive/index.php/t-128299.html You could find more debate about this.
Performance shouldn't be an issue. Using auto-increment is convenient, but some experts say that is unclean to do so. The extra required storage shouldn't be an issue in these days.
It would be nice if some of the hard core database designers from MySQL could give their opinion!
Subject
Views
Written By
Posted
4530
May 08, 2009 04:09AM
2607
May 09, 2009 11:49AM
2591
May 11, 2009 10:26AM
Re: Are varchar primary keys less efficient than autonumbers?
2730
May 14, 2009 07:42AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.