One important method for performance tuning is to decrease number of logical reads, by adding, updating, and/or refreshing indexes and statistics. To see if those changes make a difference for you, it is important to look at query statistics. Here is a sample output after set statistics io on: [sourcecode language=”text”] Table ‘Table1’. Scan count…