I have a large table with around 50 million rows and 15 columns. Whenever I read, I always need all columns so I can't split them. I have a clustered index on the table with 4 keys (ALL INT) and I always read data using those keys and if I see the query plan it shows 84% for clustered index seek.
But the performance is still slow, my queries are fairy simple like this
select CountryId, RetailerID, FY, sum(col1), sum(col2),.....sum(col15) from mytable a join product p on a.productid = p.id join ...... join ..... join ...... join ..... Where ....... group by CountryId, RetailerID, FY
I'm not using any IN operator or any sub queries here on any inline functions... which I know obviously make it slow. I've looked at partitioning but not sure about that, can I get some performance improvement by doing partition?
OR is there anything else I can do?
I'm using SQL Server 2012 Enterprise Edition