January 23, 2013 at 4:00 pm
I have a query which is doing a left join a table which shows 25K executions, i think it is executing for each record because the output is also 25k. Any thoughts how to optimize it? I will try to post some more details.
January 23, 2013 at 4:07 pm
sqldba_newbie (1/23/2013)
I have a query which is doing a left join a table which shows 25K executions, i think it is executing for each record because the output is also 25k.
Shows 25k executions where?
Any thoughts how to optimize it?
A completely unknown query on a completely unknown set of tables that have a completely unknown set of indexes with a completely unknown data volume... No thoughts at all.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
January 23, 2013 at 5:22 pm
Heya Newbie,
We're gonna need a bunch more to help you on this one, including the .sqlplan and query. Check out the second link down in my signature on the left (index tuning help) and it'll show you all the pieces that will let us help you on this. Optimization questions are intricate and we need a lot of information to help you.
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply