Re: Primary Index Key, Performance hit?

From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Tue, 1 Oct 2002 08:46:05 +0100
Message-ID: <anbjs1$15h$1$8300dec7@news.demon.co.uk>

This may help:

http://www.jlcomp.demon.co.uk/faq/ind_faq.html

Article title:

---

Which type of index can Oracle access faster, a character key or a numeric key ?

--
Regards

Jonathan Lewis
http://www.jlcomp.demon.co.uk

Next Seminar dates:
(see http://www.jlcomp.demon.co.uk/seminar.html )

____USA__________November 7/9 (MI), 19/21 (TX)
____England______November 12/14

The Co-operative Oracle Users' FAQ
http://www.jlcomp.demon.co.uk/faq/ind_faq.html








A. G. Mueller wrote in message ...


>Is there a performance hit making the primary index key of a table a

>VARCHAR2(22) versus a NUMBER(6)?  Just wondered as I can't find out

>information either way.

>

>-== A. G. Mueller ==-

>

>

Received on Tue Oct 01 2002 - 02:46:05 CDT