>>Can you tell a bit more about the structure of your tables and what exactly you're trying to achieve with this query?
>>
>>Also can you do a simple join with Monitor table instead?
>
>The simple join was not optimized. I had results in 0.3 seconds where I get results in 0.001 second with the 2nd approach. But, this seems to create a deadlock. So, I will use the EXISTS approach and we'll see how it goes.
This is a bit strange. What indexes do you have? EXISTS and INNER JOIN should perform the same, IMHO, but I would be curious to see the difference in speed.
If it's not broken, fix it until it is.
My Blog