Buenos días compañeros.
Estoy realizando una consulta extensa en la base de datos que había funcionado muy bien hasta hace unos días. Hace unos días ya se tarda demasiado en cargar hasta notificar ‘ERROR 500’, aquí les dejaré la consulta:
SELECT tbl_consumo_final.NUM_CONSUMO as NUM_CONSUMO,tbl_visitas.ACTIVIDAD AS ACTIVIDAD,tbl_visitas.DIRECCION as DIRECCION,tbl_visitas.ZONA_TRABAJO as CIUDAD_DEL_EVENTO,tbl_visitas.OT as OT,tbl_visitas.NUMERO_CUENTA AS CUENTA,tbl_visitas.NODO AS NODO,substring(tbl_consumo_final.OBSERVACION,1,100) AS OBSERVACIONES,tbl_consumo_final.OBSERVACION,tbl_consumo_final.FECHA_INST AS FECHA_INST,tbl_cons_fact_mat_final.COD_FACTURACION AS COD_FACTURACION,tbl_cons_fact_mat_final.CANT_FACTURACION AS CANT_FACTURACION,tbl_cons_fact_mat_final.COD_MATERIAL AS COD_MATERIAL,tbl_material.DESCRIPCION AS DESCRIPCION,tbl_cons_fact_mat_final.CANT_MATERIAL AS CANT_MATERIAL,tbl_consumo_final.cod_cierre AS COD_CIERRE,tbl_consumo_final.CC_TECNICO AS CC_TECNICO,tbl_personal.nombres as NOMBRE_TECNICO,tbl_consumo_final.CC_AUX AS CEDULA_AUXILIAR,AUXILIAR.nombres as NOMBRE_AUXILIAR FROM tbl_consumo_final inner join tbl_personal on tbl_consumo_final.CC_TECNICO=tbl_personal.EXTERNAL_ID inner join tbl_personal AS AUXILIAR on tbl_consumo_final.CC_AUX=AUXILIAR.EXTERNAL_ID INNER JOIN tbl_visitas on tbl_consumo_final.OT= tbl_visitas.OT INNER JOIN tbl_cons_fact_mat_final ON tbl_cons_fact_mat_final.NUM_CONSUMO=tbl_consumo_final.NUM_CONSUMO INNER JOIN tbl_material on tbl_cons_fact_mat_final.COD_MATERIAL=tbl_material.COD_MATERIAL INNER JOIN tbl_cod_consumo ON tbl_cons_fact_mat_final.COD_FACTURACION=tbl_cod_consumo.CODIGO WHERE tbl_visitas.ZONA_TRABAJO LIKE ‘VIL%’ AND CAST(tbl_consumo_final.FECHA_INST AS DATE) BETWEEN ‘2017-12-09’ AND ‘2017-12-09’ ORDER BY tbl_consumo_final.NUM_CONSUMO
Les agradecería información de poder optimizar o mejorar la consulta.CC