What indices do you have? 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 > > > > -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
