Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

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

share|improve this question

closed as unclear what you're asking by Mark Storey-Smith, Jon Seigel, Mat, dezso, Kin Aug 6 '13 at 15:58

Please clarify your specific problem or add additional details to highlight exactly what you need. As it's currently written, it’s hard to tell exactly what you're asking. See the How to Ask page for help clarifying this question.If this question can be reworded to fit the rules in the help center, please edit the question.

1  
Can you provide the query plan? –  Shawn Melton Jul 26 '13 at 22:32
    
For your purposes, how slow is "slow", and how fast is "fast"? Is the query doing any physical reads? –  Jon Seigel Jul 26 '13 at 22:43
    
How do i post query plan here? –  safeer ahmad Jul 27 '13 at 14:26
    
I think it's slow because users can't wait for a minute to see the data... –  safeer ahmad Jul 27 '13 at 14:27
    
See here for how to post an execution plan. Also, you can use comment notifications using @username. –  Jon Seigel Jul 29 '13 at 17:06