Re: [HACKERS] psql nested queries with 2000+ records

What does this show in explain? Does it use an index?

select name from games where mfr = ''

>
> At 09:54 AM 3/21/98 -0500, Bruce Momjian wrote:
>
> >Try it without the LIKE, with just an equals.
>
> amusements=> explain select name from games where name in (select name from
> game
> s where mfr = '');
> NOTICE: QUERY PLAN:
>
> Seq Scan on games (cost=207.95 size=446 width=12)
> SubPlan
> -> Seq Scan on games (cost=207.95 size=1 width=12)
>
> EXPLAIN

I ran this test:

test=> explain select * from pg_proc where oid in (select oid from
pg_proc where oid =3);
NOTICE: QUERY PLAN:

Seq Scan on pg_proc (cost=48.90 size=91 width=122)
SubPlan
-> Index Scan on pg_proc (cost=2.05 size=1 width=4)

and it used the index in the subquery. Please let us about the above
test.

--
Bruce Momjian | 830 Blythe Avenue
maillist(at)candle(dot)pha(dot)pa(dot)us | Drexel Hill, Pennsylvania 19026
+ If your life is a hard drive, | (610) 353-9879(w)
+ Christ can be your backup. | (610) 853-3000(h)