On Jan 12, 2004, at 08:09 AM, Douglas Sims wrote:
I think... you don't have an index on the "Incident" field itself, just on (Date, Incident, Type, Task) which means that it concatenates those fields and orders the result - thus this may be virtually useless if you're looking for a specific incident within a large date range. Since your query has a specific incident number, indexing that field would probably help a lot.
Thanks for the help, Douglas. That was the ticket. We're back under a second for queries now.
Mike Schienle, Custom Visuals http://www.customvisuals.com/
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
