Left join muy lento

[juansoller75]

SHOW CREATE TABLE tbcandidatos

Código MySQL:

CREATE TABLE `tbcandidatos` (
 `ccta_stremail` varchar(100) COLLATE latin1_spanish_ci NOT NULL,
 `sin_estudios` int(1) NOT NULL,
 `sin_experiencia` int(1) NOT NULL,
 `cand_datenacimiento` date NOT NULL,
 `cand_intgenero` tinyint(4) NOT NULL,
 `cand_strtelefono` varchar(100) COLLATE latin1_spanish_ci NOT NULL,
 `cand_intpais` tinyint(4) NOT NULL,
 `cand_intprovincia` tinyint(4) NOT NULL,
 `cand_strpoblacion` varchar(150) COLLATE latin1_spanish_ci NOT NULL,
 `cand_intnacionalidad` tinyint(4) NOT NULL,
 `cand_intautonomo` tinyint(4) NOT NULL,
 `cand_intconductor` varchar(200) COLLATE latin1_spanish_ci NOT NULL,
 `cand_strfoto` varchar(150) COLLATE latin1_spanish_ci NOT NULL,
 `cand_inactivo` tinyint(4) NOT NULL,
 `cand_strpuestoideal` varchar(200) COLLATE latin1_spanish_ci NOT NULL,
 `cand_intcategoria` tinyint(4) NOT NULL,
 `cand_strsubcategorias` varchar(300) COLLATE latin1_spanish_ci NOT NULL,
 `cand_strprovincias` varchar(300) COLLATE latin1_spanish_ci NOT NULL,
 `cand_intviajar` tinyint(4) NOT NULL,
 `cand_intmudanza` tinyint(4) NOT NULL,
 `cand_intofertas` tinyint(4) NOT NULL,
 `cand_intperfil` tinyint(4) NOT NULL,
 `fech_last_login` date NOT NULL,
 `fech_last_postu` date NOT NULL,
 `fecha_last_pdf` date NOT NULL,
 `fecha_las_linkedin` date NOT NULL,
 `almacen` int(1) NOT NULL,
 `integridadRelacional` int(1) NOT NULL,
 PRIMARY KEY (`ccta_stremail`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_spanish_ci
 

SHOW CREATE TABLE catcuentas

Código MySQL:

CREATE TABLE `catcuentas` (
 `id_cuenta` int(255) NOT NULL AUTO_INCREMENT,
 `ccta_stremail` varchar(100) COLLATE latin1_spanish_ci NOT NULL,
 `ccta_strnombre` varchar(200) COLLATE latin1_spanish_ci NOT NULL,
 `ccta_strapellidos` varchar(250) COLLATE latin1_spanish_ci NOT NULL,
 `ccta_strtelefono` varchar(100) COLLATE latin1_spanish_ci NOT NULL,
 `ccta_strpassword` varchar(20) COLLATE latin1_spanish_ci NOT NULL,
 `ccta_md5strpassword` varchar(555) COLLATE latin1_spanish_ci NOT NULL,
 `ccta_inttipo` tinyint(4) NOT NULL COMMENT '1. Empresa - 2.Candidato',
 `ccta_intactivo` tinyint(4) NOT NULL,
 `codigo` varchar(20) COLLATE latin1_spanish_ci NOT NULL,
 `fecha_alta` date NOT NULL,
 `cookie` varchar(100) COLLATE latin1_spanish_ci NOT NULL,
 PRIMARY KEY (`id_cuenta`,`ccta_stremail`)
) ENGINE=InnoDB AUTO_INCREMENT=68664 DEFAULT CHARSET=latin1 COLLATE=latin1_spanish_ci
 

SELECT COUNT tbcandidatos

TotalNoNulos TotalNulos
54911 1

SELECT COUNT catcuentas

TotalNoNulos TotalNulos
67772 1


Un saludo,