Re: query optimization - DB

MySQL queries use 1 index per table, so to speed the query, we need to know what indices you have for the 2 tables. Thank you, Micah Gersten onShore Networks Internal Developer http://www.onshore.com Yves Sucaet wrote: > Oh, sorry I forgot to mention this. It's a MySQL database. > > ----- Original Message ----- From: "Micah Gersten" <micah@onshore.com> > To: "YVES SUCAET" <yves.sucaet@usa.net> > Cc: <php-db@lists.php.net> > Sent: Thursday, September 25, 2008 7:55 PM > Subject: Re: [PHP-DB] query optimization > > >> Other question is, what DB is this for? >> >> Thank you, >> Micah Gersten >> onShore Networks >> Internal Developer >> http://www.onshore.com >> >> >> >> YVES SUCAET wrote: >>> How could I rewrite the following query so it runs faster: >>> >>> select distinct location from blockunit where blockid in ( >>> select bu.blockid from blockunit bu inner join interactionparts ip on >>> (bu.blockid = ip.part) >>> where ip.blockid in >>> >>> (110936,110937,111641,111642,113140,113141,114925,114926,121161,121162,124087, >>> >>> >>> 124088,124562,124563,133358,133359,133409,133410,135304,135305,136096) >>> union >>> select bu.blockid from blockunit bu >>> where bu.blockid in >>> >>> (110936,110937,111641,111642,113140,113141,114925,114926,121161,121162,124087, >>> >>> >>> 124088,124562,124563,133358,133359,133409,133410,135304,135305,136096) >>> ) >>> >>> Thanks in advance, >>> >>> Yves >>> >>> >>> >>> >> > > >