Re: Help creating index's for this query...

[Cory at SkyVantage]

gerald_clark wrote:
Cory at SkyVantage wrote:
*************************** 1. row ***************************
          id: 1
 select_type: SIMPLE
       table: status
        type: ALL
possible_keys: NULL
         key: NULL
     key_len: NULL
         ref: NULL
        rows: 100
       Extra: Using where
 using indicies here, so I don't understand what you are asking.

There are no indexes used on the above.   Right?  or am I missing 
something?  (the joins are using the pk index's, but the WHERE part of 
the statement isn't, because there are no index's on those fields.)

Cory

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]