Re: POSTGRESQL Optimizer

On Fri, 2002-06-21 at 14:45, Tourtounis Sotiris wrote:
> I wonder how i can enforce the PostgreSQL optimizer in order to use the
> indexes in cases of SQL queries with comparison (<,>) and not equality. I
> create a table with 4 attributes, the two of them are types of integer8 in
> PostgreSQL and i create to those 2 indexes (which by default are B+trees).
> However they didn't work. I would appreciate any comment.
try

select * from foo where bar > '12345';

insted of

select * from foo where bar > 12345;

did you vacuum analyze before ?

Cheers
Tycho

--
Tycho Fruru tycho(at)fruru(dot)com
"Prediction is extremely difficult. Especially about the future."
- Niels Bohr