SUBQUERY PROBLEM

[Odimar Tomazeli]

Hi everybody,

I'm having problems with subquery a simple query takes almost haft an hour to run

Here the table structure:

CREATE TABLE `consolidatetaxe`.`nm1_customer_exempt` (
`idnm1_customer_exempt` bigint(20) NOT NULL auto_increment,
`ReportID` varchar(8) NOT NULL,
`ReportName` varchar(50) default NULL,
`FromDate` datetime default NULL,
`ToDate` datetime default NULL,
`Market` varchar(3) default NULL,
`Entity` varchar(8) default NULL,
`Submarket` varchar(30) default NULL,
`CurrencyCode` varchar(3) default NULL,
`Customer` varchar(10) default NULL
PRIMARY KEY (`idnm1_customer_exempt`),
KEY `IDX_FromDate` (`FromDate`,`ReportName`),
KEY `IDX_ToDate` (`ToDate`),
KEY `IDX_FromDateToDate` (`FromDate`,`ToDate`),
KEY `IDX_SubmarketCode` (`Submarket`),
KEY `IDX_ALL` (`Market`,`Entity`,`Submarket`,`CurrencyCode`,`Customer`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;


here my query

SELECT DISTINCT ReportID, ReportName, FromDate, ToDate, Market, Entity, Submarket, CurrencyCode, Customer
FROM nm1_customer_exempt
WHERE FromDate >= '2005-12-01 00:00:00' and ToDate <= '2005-12-31 00:00:00'
and CONCAT(Market,Entity,Submarket,CurrencyCode,Customer)
NOT IN (SELECT DISTINCT CONCAT(nce.Market,nce.Entity,nce.Submarket,nce.CurrencyCode,nce.Customer)
FROM nm1_customer_exempt nce
WHERE nce.FromDate >= '2005-11-01 00:00:00' and nce.ToDate <= '2005-11-30 00:00:00')

Here I'm trying to display the customers added in the current month that weren't in the last month.

Anyone have any idea, why is taking so long?

Thanks


Odimar Tomazeli