Alberto, is there anyone in your office wearing a blue shirt?
When you answer this, do you count all the people who are wearing blue shirts before answering yes or no. Or do you see just one person wearing a blue shirt and answer yes. Which is quicker for you to do?
The query you are describing in your postings seems to be counting the total number of blue shirts just to decide if at least one person has a blue shirt.
Take another look at the previous posts in this thread. If your query just needs to know a true or false answer, look at the suggestion on how to make this work.
Original author: https://github.com/SQL-FineBuild/Common/wiki/ 1-click install and best practice configuration of SQL Server 2019, 2017 2016, 2014, 2012, 2008 R2, 2008 and 2005.
When I give food to the poor they call me a saint. When I ask why they are poor they call me a communist - Archbishop Hélder Câmara