gistfile1.txt

mysql> explain SELECT logtable.SIPCallID, CallID, logtable.TimeRinging, logtable.TimeConnected, logtable.TimeTerminated, ConfServerIP, SIPCallIDAgent, logtable.TimeInitiated, logtable.GatewayIP, logtable.GatewayIPAgent, logtable.TimeConnected, UNIX_TIMESTAMP(logtable.TimeTerminated)-UNIX_TIMESTAMP(logtable.TimeConnected), logtable.var5, UserTelephoneNumber, logtable.var1, logtable.var2, logtable.var3, logtable.var4, InboundTelephoneNumber, logtable.TelephoneNumber, 'not applicable' AS `CallerIP` , 'not applicable' AS `Referrer` , Population, AvgTravelTimeToWork, MedianHouseholdIncome, PerCapitaIncome, MedianEarnings, MedianContractRent, MedianRentAsked, MedianGrossRent, MedianPriceAsked, MedianRealEstateTaxes, Households, OwnerHouseholds, RenterHouseholds, NDISCache.Src, NDISCache.phone, NDISCache.LastName, NDISCache.CNAM, NDISCache.FirstName, NDISCache.StreetAddress, NDISCache.City, NDISCache.State, NDISCache.Zip, NDISCache.Zip AS NDISZip, NDISCache.alreadytriedpremium, cen.*, callerinfotable.callerinfo, UserTelephoneNumber  FROM reportingarchive.CallTransferLogs logtable  LEFT JOIN Reference.PhoneData ON NPA = IF('1'=SUBSTRING(UserTelephoneNumber, 1,1), SUBSTRING(UserTelephoneNumber, 2, 3), 'xxx') AND NXX = SUBSTRING(UserTelephoneNumber, 5, 3)  LEFT JOIN Reference.NDISCache ON NDISCache.phone = UserTelephoneNumber  LEFT JOIN Reference.Census cen ON cen.Zip = PhoneData.zip  LEFT JOIN webcare.InboundTransfer callerinfotable ON callerinfotable.upbid = logtable.LinkID LEFT JOIN webcare.Organizations ON Organizations.uoid = logtable.ClientID LEFT JOIN MCURecordings.MCURecordings ON CallID = logtable.SIPCallID AND isdeleted = '0'  WHERE logtable.TimeInitiated  BETWEEN '2010-02-01 00:00:00'  AND '2010-02-28 23:59:59' AND logtable.ClientID = '200106293226'  AND ( logtable.var2 LIKE '29361975' )   AND TimeUserConnected >= logtable.TimeInitiated  AND (logtable.TimeConnected != '0000-00-00 00:00:00'  AND logtable.TimeTerminated >= logtable.TimeConnected) ORDER BY '1', logtable.TimeConnected;
+----+-------------+-----------------+--------+-----------------------------------------+--------------+---------+-----------------------------------------------+-------+-----------------------------+
| id | select_type | table           | type   | possible_keys                           | key          | key_len | ref                                           | rows  | Extra                       |
+----+-------------+-----------------+--------+-----------------------------------------+--------------+---------+-----------------------------------------------+-------+-----------------------------+
|  1 | SIMPLE      | logtable        | ref    | TimeInitiated_ind,ClientID_ind,var2_idx | ClientID_ind | 15      | const                                         | 35416 | Using where; Using filesort |
|  1 | SIMPLE      | PhoneData       | eq_ref | PRIMARY                                 | PRIMARY      | 6       | func,func                                     |     1 |                             |
|  1 | SIMPLE      | NDISCache       | eq_ref | PRIMARY                                 | PRIMARY      | 18      | reportingarchive.logtable.UserTelephoneNumber |     1 |                             |
|  1 | SIMPLE      | cen             | eq_ref | PRIMARY                                 | PRIMARY      | 5       | Reference.PhoneData.Zip                       |     1 |                             |
|  1 | SIMPLE      | callerinfotable | eq_ref | PRIMARY                                 | PRIMARY      | 8       | reportingarchive.logtable.LinkID              |     1 |                             |
|  1 | SIMPLE      | Organizations   | eq_ref | PRIMARY,uoid                            | PRIMARY      | 8       | reportingarchive.logtable.ClientID            |     1 | Using index                 |
|  1 | SIMPLE      | MCURecordings   | eq_ref | PRIMARY                                 | PRIMARY      | 62      | reportingarchive.logtable.SIPCallID           |     1 |                             |
+----+-------------+-----------------+--------+-----------------------------------------+--------------+---------+-----------------------------------------------+-------+-----------------------------+
7 rows in set (0.00 sec)

mysql>