Regarding Where clause condition

See more:

SQL

server

Dear Friends, I have a confusion regarding the where clause in SQL Server.

Let me explain it with an example. Lets say there is a table named Employee which contains two columns EMP_Name and EMP_City.

Now when i run this query:-

select * from Employee where EMP_Name='Arun'

Then it returns me 5000 records and when i run the following query:-

select * from Employee where EMP_City='delhi'

I get 10,000 records. So now when i run the query with both the filters ON like this :-

select * from Employee where EMP_City='delhi' and EMP_Name='Arun'

OR

select * from Employee where EMP_Name='Arun' and EMP_City='delhi'

Then from the above two queries which queyr execution time will be less means which query will return the result faster and why.

Thanks

Varun Sareen