Re: Index does not working.

1)
select * from my_table where active and deleted
--------------
Seq Scan on my_table (cost=100000000.00..100000180.00 rows=2500 width=56)
Filter: (active AND deleted)

2)
select * from my_table where active = true and deleted = true
-------------
Index Scan using my_table_index on my_table (cost=0.00..369.00 rows=2500
width=56)
Index Cond: ((deleted = true) AND (active = true))

2005/6/13, Douglas McNaught <doug(at)mcnaught(dot)org>:
>
> Dan Black <fireworker(at)gmail(dot)com> writes:
>
> > First query does not use index in contrast to two query.
> >
> > Why?
>
> You don't give enough information. Post EXPLAIN ANALYZE output for
> both queries and perhaps someone can help.
>
> -Doug
>

--
Verba volent, scripta manent
My ISP - http://www.netbynet.ru