Re: char vs varchar2

On Thu, 21 May 1998 20:46:15 GMT, yren_at_epsilon.com <yren_at_epsilon.com> wrote:
>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?

The char type uses blank-padded comparison semantics, but with 1 character there should be a whole lot of performance difference. Of more concern may be using a 1 character string to primary index a large table. I smell a design problem.

>
>Thanks.
>
>
>-----== Posted via Deja News, The Leader in Internet Discussion ==-----
>http://www.dejanews.com/ Now offering spam-free web-based newsreading

--
These opinions are my own and not necessarily those of Information Quest

or Pebble In The Sky                     http://www.informationquest.com

http://ourworld.compuserve.com/homepages/joel_garry jgarry@nospameiq.com
"See your DBA?"  I AM the @#%*& DBA!     Remove nospam to reply.  Sorry.