Re: char vs varchar2
Date: 1998/05/27
Message-ID: <01bd88da$4ef0e4a0$535173ce_at_sdaly.papajohns.com>#1/1
Two things here. 1 character is not enough for a large table when it comes to a primary key. Set your primary key to be something else. If that one character is that significant then think about it's cardinality. Assuming there is not more than 31 different values that can be in that one character field, it would be usefull to create a secondary index on that field that is a bitmapped index. Bit mapped indexes are much quicker than normal indexes when coupled with a binary -tree primary key.
Derek Licciardi
dlicciardi_at_tcipro.com
yren_at_epsilon.com wrote in article <6k23qn$3s4$1_at_nnrp1.dejanews.com>...
> I have a large table. Its primary index is one character string.
> Could anyone tell me which datatype ( char(1) or varchar2(1) )
> I should use? What are advantages in terms of performance?
>
> Thanks.
>
>
> -----== Posted via Deja News, The Leader in Internet Discussion ==-----
> http://www.dejanews.com/ Now offering spam-free web-based newsreading
>
Received on Wed May 27 1998 - 00:00:00 CEST