Re: Speed of Oracle Indexes

From: Neil Cudd <neil_at_cudd.demon.co.uk>
Date: Tue, 9 Mar 1999 09:23:51 -0000
Message-ID: <920971615.15882.0.nnrp-11.c2de6f3d@news.demon.co.uk>

To provide the fastest 'table scanning' : don't apply any indicies !

sorry... being a smart ass :-/

I would go for number since you can hold a larger range of unique values using
less space, so the traverse time across any part of the index object is smaller.

Makes sense to me.

cocchino75_at_my-dejanews.com wrote in message <7c1nei$17s$1_at_nnrp1.dejanews.com>...
>Help!
>
>I am currently designing a new database. All my tables are designed in 4th
>normal form with primary key indexes on each. I am trying to decide what
>datatype to use for my indexes. Which datatype should I use to provide the
>fastest table scanning. I am leaning towards NUMBER, but I really am not
sure.
>
>Kudos to whoever can answer this one.
>
>-Charlie
>
>-----------== Posted via Deja News, The Discussion Network ==----------
>http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own
Received on Tue Mar 09 1999 - 03:23:51 CST