March 28, 2010 at 3:28 pm
Good morning,
I have a problem with this query :
select f1.field_one from table1 t1
left join table2 t2 on t1.id = t2.id
left join table3 t3 on t2.id = t3.id
left join table4 t4 on t2.id = t4.id
left join table4 t5 on t2.id = t5.id
is very slow, but if i change the first left into inner it becames faster.
the strange thing is that in another db, virtually identical, i don't have this problem.
Some ideas ?
Thanks in advance.
Massimo
March 28, 2010 at 4:08 pm
Nope, not from what you have posted. Please read the 2nd article I have referenced below in my signature block and follow the instructions on what you should post to get the best help quickly.
March 29, 2010 at 4:35 am
massimo.valtolina (3/28/2010)
the strange thing is that in another db, virtually identical, i don't have this problem.
Data Volume can be different or indexes/statistics might be out of dated. can you post your query and execution plan along with table and index schema but before that refer what Lynn asked you to do.
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply