Hi, I have a table logging our website activity with about 60 M of rows. One user has for itself more than 1 M rows. When I do a count(distinct), it takes two seconds. I was wondering if there is a way to speed that up? Here's the table CREATE TABLE [dbo].[tbl_logs]( [id] [int] NOT NULL, [dateAdded...