Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Index performance: integer vs. varchar
"Chuck" <chuck_hamilton_at_yahoo.com> wrote in message news:<a8s7cr$ufvo7$1_at_ID-85580.news.dfncis.de>...
> -----BEGIN PGP SIGNED MESSAGE-----
> Hash: SHA1
>
> Anyone ever done a performance comparison between integer indexes vs.
> varchar indexes? What was the result? Did one perform significantly
> faster than the other?
>
> -----BEGIN PGP SIGNATURE-----
> Version: PGPfreeware 7.0.3 for non-commercial use <http://www.pgp.com>
>
> iQA/AwUBPLGg2Gm5A4kkb4ZsEQKfNgCgnE0hJ2rbH39j5KVVLdMHTz6H5CEAn2es
> aTXxy1iaCZpIhXPvEP/vcLOD
> =Bt0/
> -----END PGP SIGNATURE-----
I remember reading a test posted to metalink once and basically there
was very little difference between the two for comparable keys.
Numeric did seem to have a small advantage for the tests displayed.
HTH -- Mark D Powell -- Received on Mon Apr 08 2002 - 12:09:16 CDT