Re: which column type char,varchar2 is better for index?

From: Alan <alan_at_erols.com>
Date: Mon, 14 Jun 2004 15:28:42 -0400
Message-ID: <2j6cj3Ft0rmrU1@uni-berlin.de>

"Daniel Morgan" <damorgan_at_x.washington.edu> wrote in message news:1087071115.755274_at_yasure...
> Alan wrote:
>
> >>But as I doubt you will let me give you the answer ... there is not
> >>a single valid reason I can think of in Oracle to ever use a CHAR
> >>column. And performance is only a small part of the reason.
> >>
> >
> >
> > This is not a valid reason, but I use CHAR(1) in place of the
non-existant
> > Boolean (no, I don't want to argue about the need for Boolean data), or
> > maybe for a flag. Just for ease when scanning designs and so on.
>
> But do keep in mind that 0 and 1 would be more efficient for that purpose.

Not in terms of storage space...

>
> --
> Daniel Morgan
> http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp
> http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp
> damorgan_at_x.washington.edu
> (replace 'x' with a 'u' to reply)
>
Received on Mon Jun 14 2004 - 14:28:42 CDT