Varchar field type as primary key and basis of index
Posted by:
tomas bar
Date: January 22, 2009 11:13AM
Hi,
My question is whether a field of varchar(45) constitutes a good primary key and is it efficient to create an index on this kind of key . This field contains a URI and is unique, but would it be better to create an auto-increment field as primary key and basis for index?
Thank you very much.
Tomas Bar
Subject
Views
Written By
Posted
Varchar field type as primary key and basis of index
17417
January 22, 2009 11:13AM
12025
January 22, 2009 12:36PM
7061
January 23, 2009 05:06AM
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.