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
It's "my" world. You're just living in it.