[Mysql] index 강제로 태우기
#explain
SELECT
a.collect_date
, b.building_name
, b.system_group_name
, b.system_name
, b.equip_group_name
, b.equip_name
, a.ddc_id
, b.point_name
, b.unit_name
, b.unit_visual_name
, a.point_value
, a.point_change_value
FROM point_data a
INNER JOIN (select
point_key
,building_name
, system_group_name
, system_name
, equip_group_name
, equip_name
, point_name
, unit_name
, unit_visual_name
FROM point_conf
where 1=1
AND point_key <> ''
AND building_id <> ''
AND system_id <> ''
AND equip_id <> ''
AND ddc_id <> ''
AND point_id <> ''
) b
ON a.point_key = b.point_key
AND a.collect_date >= '2016-10-09'
AND a.collect_date < '2016-10-10'
WHERE 1=1
???모르겟다