Re: Speed of varchar vs. char in indices

* Mirko Zeibig <mirko(at)picard(dot)inka(dot)de> [010124 09:07] wrote:
> Hello,
>
> I have a table:
>
> CREATE TABLE pge (
> pge_id SERIAL,
> pge_path CHAR(255) CONSTRAINT ak_pge_path UNIQUE,
> PRIMARY KEY (pge_id)
> );
>
> >From other tables I now reference pge_id as well as pge_path. Somewhere I
> have read that indices on CHAR are faster than those on VARCHAR.

No clue, but as a somewhat related note, I don't think indexes work
properly when a join is attempted on a CHAR and VARCHAR column.

--
-Alfred Perlstein - [bright(at)wintelcom(dot)net|alfred(at)freebsd(dot)org]
"I have the heart of a child; I keep it in a jar on my desk."