Re: Index type performance ???

From: Daniel Morgan <damorgan_at_exesolutions.com>
Date: Wed, 10 Apr 2002 18:40:01 GMT
Message-ID: <3CB486FC.362570DB@exesolutions.com>

Number. Though I highly doubt you will ever see the difference.

Daniel Morgan

Brian wrote:

> 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 - 13:40:01 CDT