In case you have your own slow SQL query, you can optimize it automatically here.
For the query above, the following recommendations will be helpful as part of the SQL tuning process.
You'll find 3 sections below:
ALTER TABLE `positionview` ADD INDEX `positionview_idx_outboun_referen_respons_equipme` (`outbound`,`referenceIdentifier`,`responseType`,`equipmentTimestamp`);
SELECT
*
FROM
(SELECT
DISTINCT
ON (iNumber) positionview.equipmentTimestamp,
positionview.name,
positionview.iNumber,
positionview.datauserprovidername,
positionview.latitude,
positionview.longitude
FROM
positionview
WHERE
positionview.outbound = false
AND positionview.referenceIdentifier IS NULL
AND positionview.responseType = 'XYZ'
AND positionview.equipmentTimestamp >= '2013-02-09 10:04:14.476'
AND positionview.equipmentTimestamp <= '2016-02-12 10:04:14.476'
ORDER BY
positionview.iNumber DESC) AS derivedInnerQuery
ORDER BY
derivedInnerQuery.equipmentTimestamp DESC