MySQL Forums
Forum List  »  General

Re: Can anyone help speed this up??
Posted by: Bruce D
Date: May 10, 2005 08:51AM

Sorry...I lost formatting...

Here are the indexes.
Finders:
Keyname Type Cardinality Action Field
PRIMARY PRIMARY 5659954 Drop Edit FinderID
FinderNumber INDEX 55 Drop Edit FinderNumber
StreetNumber INDEX 38242 Drop Edit StreetNumber
StreetName INDEX 82028 Drop Edit StreetName
Zip INDEX 1510 Drop Edit Zip
Phone INDEX 2829977 Drop Edit Phone
AssignmentID INDEX 435381 Drop Edit AssignmentID
Name INDEX 2829977 Drop Edit LastName, FirstName

Assignment:
Keyname Type Cardinality Action Field
PRIMARY PRIMARY 419649 Drop Edit AssignmentID
KitStatusID INDEX 1 Drop Edit KitStatusID
AssignCode INDEX 419649 Drop Edit AssignCode
AssignZip INDEX 1509 Drop Edit AssignZip
AssignStreet INDEX 83929 Drop Edit AssignStreet
Volunteer_FinderID INDEX 419649 Drop Edit Volunteer_FinderID
BranchID INDEX 1 Drop Edit BranchID
JobNumber INDEX 1 Drop Edit JobNumber
CurrentCard INDEX 1 Drop Edit CurrentCard

Here's the explain.

EXPLAIN SELECT Finders.Lastname, Assignment.currentcard
FROM Finders
JOIN Assignment ON Finders.assignmentid = Assignment.assignmentid
WHERE Assignment.jobnumber = '50720' AND Finders.lastname
LIKE 'DU%'

Finders range AssignmentID,Name Name 15 NULL 32284 Using where
Assignment eq_ref PRIMARY,JobNumber PRIMARY 4 Finders.AssignmentID 1 Using where

I'm using MyISAM.

Thanks for looking into this!

-bruce

Options: ReplyQuote


Subject
Written By
Posted
Re: Can anyone help speed this up??
May 10, 2005 08:51AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.