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@fruru.com
"Prediction is extremely difficult. Especially about the future."
- Niels Bohr