Cory at SkyVantage wrote:
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
How many possible values may res_status have? What percentage for each
value? It may not be possible to use an index on this field.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]