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).