How to compare two queries?

September 10, 2023 by Tarik

SET STATISTICS IO ON
SET STATISTICS TIME ON

Run the queries and compare logical reads for the various tables and execution times.