Hermouth,
Thank you so much for your reply! You were exactly right. I re-created
the index with bpchar_ops, and explain now outputs:
Index Scan using ven_code_idx on vendor (cost=2.05 rows=2 width=36)
instead of
Seq Scan on vendor (cost=738.86 rows=2 width=36)
Queries are obviously much faster now.
I am unable to find any reference to bpchar_ops in the the documentation
or the General and SQL mailing list archives. Can you tell me where I
could find out more about what "_ops" are available and what they all
mean?
Thanks again,
../fam
--
Frank A. Mandarino
fam@risca.com
On Wed, 6 Oct 1999, Herouth Maoz wrote:
> At 15:30 +0200 on 06/10/1999, Frank Mandarino wrote:
>
>
> > main=> create index ven_code_idx on vendor using btree (ven_code char_ops);
> > CREATE
>
> I didn't have time to check this, but the problem may be caused by the
> incorrect ops you are using. For char(N) it should be bpchar_ops, not
> char_ops.
>
> Herouth
>
> --
> Herouth Maoz, Internet developer.
> Open University of Israel - Telem project
> http://telem.openu.ac.il/~herutma
>
>
>
> ************
>