The first time I ran the query it took 26 seconds returning a number representing over 2 millions records. Subsequent runs with exact same query runs in 2 seconds I guess due to caching(?).

>Hi,
>
>before, optimize this:
>

>SELECT COUNT(Deceased.*) FROM Deceased JOIN ZipCross ON Deceased.Zip=Zipcross.Zip
>JOIN AreaOrder C ON B.AreaID=C.AreaID AND C.CampaignID=300
>

>
>How much time is necessary for this query?
>
>Fabio