I have attached both queries for your reference. Execution plan could not be attached.

Do we have some other way to write these queries?

Both queries are tested and giving proper results.

Yes I agree. Both queries are executing in under 1 sec. so time can't be a measurement factor, may be in a very very big query we can see some...

Yes, I also feel second query should be slower. But both are working exactly same.

I have tested same scenario with a non unique and unindexed column. Results are anyways same.

Yes, I have many other ways to perform the task. But point here is to...

Yes, There is a primary key on account.account_id

Gail Shaw,

Can you please refer to my second example where I have given the script to create table.

Ok, to understand short circuit take this example

CREATE TABLE Test_Circuit (

a INT NOT NULL PRIMARY KEY CLUSTERED,

b VARCHAR(128) NULL,

...

Dhasian, Chris

Thanks for your kind support.

Dhasian,

The query is working fine and much better then before. Good Job. But adding a where clause results in increased scan counts on "person".

Chris,

The query...

Can you provide table structure, sample data and query

It comes from Java Code, like ......where Site_id = :lablesiteid....

Hard coded value is coming from SITE_AC table. Now it is not there because I had removed some rows from script to reduce the size of attachment. you can put...

Thanks Steven.

As I mentioned earlier, This query is part of a very big and complicated query where we have more than 60 such small queries.

My requirement...

This query is part of a very big and complicated query where we have more than 60 such small queries.

All these queries are fatching value...