example.sql

SET SHOWPLAN_TEXT ON

GO

SELECT [MyColumn]
FROM [dbo].[MyTable]
WHERE [MyColumn] < 2.5
ORDER BY [MyColumn] ASC

GO

plan.txt

  |--Nested Loops(Inner Join, OUTER REFERENCES:([Expr1004], [Expr1005], [Expr1003]))
       |--Compute Scalar(DEFINE:(([Expr1004],[Expr1005],[Expr1003])=GetRangeWithMismatchedTypes(NULL,[@0],(10))))
       |    |--Constant Scan
       |--Clustered Index Seek(OBJECT:([Test].[dbo].[MyTable].[PK__MyTable__FC2639007F60ED59]), SEEK:([Test].[dbo].[MyTable].[MyColumn] > [Expr1004] AND [Test].[dbo].[MyTable].[MyColumn] < [Expr1005]) ORDERED FORWARD)