Re: Index does not working.
| От | Dan Black |
|---|---|
| Тема | Re: Index does not working. |
| Дата | |
| Msg-id | 27f60625050613130952293ecc@mail.gmail.com обсуждение исходный текст |
| Ответ на | Re: Index does not working. (Douglas McNaught <doug@mcnaught.org>) |
| Ответы |
Re: Index does not working.
Re: Index does not working. |
| Список | pgsql-general |
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))
--
Verba volent, scripta manent
My ISP - http://www.netbynet.ru
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
В списке pgsql-general по дате отправления: