On Thu, Mar 10, 2005, Geo Carncross: > Another option (probably would help other dbs too) is to use two > subselects - one on dbmail_messages and one on dbmail_physmessage. This > way, the best index for dbmail_messages can be used-
Not really responding to the post (no free brainpower this morning) but FYI, subselects are supported in MySQL 4.1+, which we should now be targeting for DBMail 2.1+... so basically, feel free to use subselects as needed. Aaron
