I'm not sure if you mean you set individual indexes on each field or you set
up a compound index.

In this set up, I would try having an index on each individual field
instead of a compound index.

Select top 10  *
FROM
  ( SELECT HitPage, URL, count(HitPage) as f1, PageTitle
    from tblSession
    WHERE LogDate >=39142
    GROUP BY HitPage, url, PageTitle  )
order by f1  desc

LogDate, HitPage, URL, PageTItle

Hi,

I ran the same query on a table with 750K records and no indexes. It took
about 10 seconds to return records the second time I ran it.

I put an index on LogDate and it ran in about 7 seconds. I then added a
second index on the other three fields. It was slower therfore I removed the
second index.

I did simplify things somewhat but it didn't seem to help any:

SELECT TOP 10 HitPage,
 URL,
 PageTitle,
 Count(HitPage) as f1
FROM tblSession
WHERE LogDate >=39142
GROUP BY HitPage, url, PageTitle  
ORDER BY 4  desc  ;

I only had three different LogDate's so YMMV.

Can you try:

SELECT TOP 10 HitPage, URL, COUNT(HitPage) as f1, PageTitle
FROM tblSession
WHERE LogDate >=39142
GROUP BY HitPage, url, PageTitle
ORDER BY COUNT(HitPage)  DESC

ie, without using a virtual table.

Vanderghast, Access MVP