Re: Char and Varchar2

From: Denny Koovakattu <denny_vk_at_my-dejanews.com>
Date: Mon, 01 Mar 1999 23:06:38 GMT
Message-ID: <7bf6hm$coq$1@nnrp1.dejanews.com>

Yes. Your space saving transalates to more number of rows per block. This will improve the performance of your table scans and also give better cache utilisation. But if you don't compute your pctfree properly this performance gain will be offset by row migration ie, if these columns are updated later to occupy more space. More number of rows per block could also effect your concurrency though it will most likely be insignificant.

Denny

In article <7beuac$52d$1_at_nnrp1.dejanews.com>, prabhakarsrini_at_my-dejanews.com wrote:
> Do I really get any performance gain in Oracle if I go
> for Varchar2 instead of Char apart from the space saving....
>
> -----------== Posted via Deja News, The Discussion Network ==----------
> http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own
>

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Mon Mar 01 1999 - 17:06:38 CST