Re: Oracle database configuration options

From: Jim Smith <jim_at_jimsmith.demon.co.uk>
Date: 1996/10/28
Message-ID: <t$2CxAAWDKdyEwf9@jimsmith.demon.co.uk>#1/1

In article <Lli5bBAR45cyEwCP_at_pbrewer.demon.co.uk>, Paul Brewer <paulb_at_pbrewer.demon.co.uk> writes
>So we thought 'OK, let's just use VARCHAR2 all the time', but were
>advised that this wasn't a good idea, as there would be a significant
>performance impact when using VARCHAR2 columns in indexes, so we didn't
>bother.
>We're not yet too far down the road to change our approach, and would
>welcome any comments or suggestions on this.

I don't know of any formal trials, but the general view seems to be that there is no significant performance hit when using VARCHAR2

-- 
Jim Smith

Received on Mon Oct 28 1996 - 00:00:00 CST