Hi Brannon, * Brannon King <[EMAIL PROTECTED]> [2006-05-23 20:05]: > Thank you for taking the time to sort out my query!
NP. I have only recently studied SQL in depth, and this was an interesting exercise. > This one above was as slow as the original. Yes, as expected – it is exactly the same query, only written slightly differently as a starting point so I could actually see what was going on. > But this one was twice as fast! I was able to use Mr. Cote's > suggestion of EXPLAIN QUERY PLAN to look at the indexes being > used and make it run even faster. Great. :-) Regards, -- Aristotle Pagaltzis // <http://plasmasturm.org/>