Hello, I have a query running on *one* table (not a join), in the explain syntax, I find out that it will be using "range" for the type, which I understand isn't as good as "ref". How big of a problem is it for a non-join query.
Here's a sample query: select title, author, book_id from books where member_id = 3 and book_id in (9,10,23,25); I have lots of keys, as you can see below [all of them are needed, and all of them will be in conjunction with "member_id" so I've added keys like index(member_id, title)] Here's explain: *************************** 1. row *************************** table: books type: range possible_keys: PRIMARY,member_id,member_id_2,member_id_3,member_id_4,member_id_5,member_id_6,member_ id_7,member_id_8,member_id_9,member_id_10,member_id_11 key: PRIMARY key_len: NULL ref: NULL rows: 4 Extra: Thanks in advance, -- Hans Anderson -=- http://www.hansanderson.com | PHP, SQL Databases, Flash 5 Animation & http://www.goofiness.com | Programming, Audio Production. --------------------------------------------------------------------- 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
