@ypercubeᵀᴹ I understand what you're saying. The
exact query was
SELECT ColumnA, ColumnB, ColumnC FROM Table1 WHERE ColumnA = 123 AND ColumnB = 987
. The execution plans were the same, minus the difference in which index was used to
seek on. The table itself was in the billions of records, and the predicates above probably returned millions of records (if I recall correctly). Again, I understand it's not a common case but in the example above the difference was of measurable seconds after testing both ways multiple times. The hardware of the server was modest though (e.g. 16 GB of RAM). —
J.D. 2 hours ago