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@mcnaught.org>: Dan Black <fireworker@gmail.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