Frank, That was only an attempt to optimize it. My query is rather simple in its structure (only two table joins, with few conditions) If helps you...
Sorry I need "last" rows. I haven't noticed the article was talking about "random" rows, especially that in my particular test case, has selected...
Greetings<br /><br />I noticed some traffic around here <img src='/community/emoticons/emotion-1.gif' alt=':)' /><br />Thank you for your time spent...
Grretings<br /><br />Thank you for your quick answer. Yes, you are right, there is something very wrong with my table structure <img...
forgot to tell : i am using microsoft sql 2005
Hello all I have a query optimization problem, if anyone can help me. I have an application that periodically scans a database, but it only needs to...
Separate names with a comma.