Re: Highly obscure and erratic

On Wed, 19 Jun 2002, Varun Kacholia wrote:

>
>
> > > hi,
> > >  I cannot get what causes the difference in the execution of these 2 commands
> > > 1. SELECT * FROM dbmedia WHERE ID IN ((SELECT id FROM wdmedia WHERE word = 'whatever') )  LIMIT 20;
> > > 2. SELECT * FROM dbmedia WHERE ID IN (1234,2345,1242,1256,1245,1567,2222,22,345,234,567,456,35,56) ;
> >
> > The former is not very well optimized (see the FAQ for suggestions on
> > using EXISTS instead).
>  hi ,
>   Had a look at that..
>   but still it is toooo slow :(
>   when is it intended to be fixed up??

What does explain show for the exists version?