> Im running the following query: > > SELECT > user.nickname, > user.id, > user_detail.points > FROM > user, > user_detail > WHERE > user.details = user_detail.id > AND user.id > 101 > AND user.language = 'en' > ORDER BY user_detail.points DESC > LIMIT 5; > > > > I don't really know how LEFT JOINS, INNER JOINS and so on work, but I want > to increase the performance of the query. > This is the result of the EXPLAIN for the query: >
if you would like to learn more about queries and if you have a windows box for a front end, download corereader from http://corereader.com it will let you quickly do and re-do join queries just by clicking on your database objects, so you can concentrate on developing logic without worrying about syntax. when you get the query that you like, copy the sql code into your app. -- John Ragan [EMAIL PROTECTED] http://www.CoreReader.com/ --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
