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?