May 15, 2012 at 2:25 am
I have attached following tables as respective indexes on it.
table having data size as mentioned.
while executing one query using this tables with joins and where condition,
where condition details :
columns doesn't comes in the indexes --summary.strInvStatus ,store.blnCost
where condition columns comes in the one indexes - s.strRescanSW ,s.strEmptyStatus,store.intRegion,s.intAreaNo,d.strSku,d.strDeleteSW,d.fltPrice
one column comes in two indexes - s.intStickerNo,store.intStore
it takes long time
as near about 30 mins.
How should i speed up query time ??
May 15, 2012 at 2:30 am
Hi could you please follow the second link in the signature block below on posting code and post the DDL of the tables along with sample data. Also please provide the SELECT statement you are running along with the execution plan.
Thanks
May 15, 2012 at 2:35 am
Also it could be useful to know the HW-Config of your Box, namely
- CPUs
- I/O Channels
- Memory
- possibly NUMA aware
- what version of SQL Server with Service Pack
- x64/x86
May 15, 2012 at 2:41 am
a starting point might also be to drop the indexes on at least
tblStore
tblSummary
For
tblSticker
tblStickerRange
that might be a solution also, but is depended on the size/config of your box.
Also, am I reading that correctly that 'tblDetail' has indexes on 13 columns?
How wide is your table?
Are some of those columns 'included' columns in the index?
May 15, 2012 at 7:53 am
If you want some real help please read the following article. How to Post Performance Problems[/url]
Without some details there is <0% chance that anybody will be offer any really good advice about how to make your code faster.
_______________________________________________________________
Need help? Help us help you.
Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.
Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/
May 15, 2012 at 8:09 am
Sean Lange (5/15/2012)
If you want some real help please read the following article. How to Post Performance Problems[/url]Without some details there is <0% chance that anybody will be offer any really good advice about how to make your code faster.
Quite true. Without the details that the article shows you to provide (and how to post it) the best you will get are wild shots in the dark. Yes, it is possible that one of those may hit the mark, but how long to you really want to wait to get good, well reasoned answers?
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply