Paresh Motiwala (8/20/2014)

---

This result should tell you:

Query Rows Time of execution

w/o compressionwith compressionwith Columnar Indexes select * from warehouse.[dbo].[Timekeeper_Matter_Time_Summary_Period] 1,102,894 69 371

select * from warehouse.[dbo].Matter_Timekeeper_History 2,796,014 78 7878

basically the query runs approximately 5.5 times longer with columnar index in one table and no improvement in the second one.

anybody have any clues as to where I should look?

Cheers

Paresh