Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Index type performance ???
I have an question regarding the index type of
a primary key. I have to store object instances ids,
each instance has a 128 bit GUID as a primary
key/foreign key for mutiple tables. These will
be a very large tables so performance is critical.
For performance reasons, is it better to have a primary key of VARCHAR(32) or NUMBER(28)?
Any ideas or insights?
TIA. Brian Received on Wed Apr 10 2002 - 11:56:18 CDT