Brent Baisley wrote:
about the same amount of time, then you don't have a proper index. The query above needs to read the entire table to compile the stats, your query should just need to read the records that are NJ if it really is using the index correctly.The results would also be interesting since if over half the entries are from one state, the index would be ignored anyway, correct?
--
Michael T. Babcock
C.T.O., FibreSpeed Ltd.
http://www.fibrespeed.net/~mbabcock
---------------------------------------------------------------------
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
