Re: Question about indexing!

On Tue, 2 Oct 2001, [euc-kr] Jeong Jaeick, ������ wrote:

> select * from pgsql_bbs where topic = 'qna' and deleted < 2 
>        order by gid desc, pos asc limit 20, 0;
> 
> But this query is not using index!
> 
> The next is result of explain of this query:
> 
> dsn=# explain select * from pgsql_bbs where topic = 'qna' and deleted < 2 
> dsn-#        order by gid desc, pos asc limit 20, 0;
> NOTICE:  QUERY PLAN:
> 
> Limit  (cost=15.71..15.71 rows=11 width=245)
>   ->  Sort  (cost=15.71..15.71 rows=11 width=245)
>         ->  Index Scan using pgsql_topic_deleted on pgsql_bbs  (cost=0.00..15.51 rows=11 width=245)

It appears to be using the topic_deleted index according to this 
explain output.
How many rows actually have topic='qna' and deleted<2?