>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.