I stumbled upon some strange behavior that I’d like to understand:
When executing a query as I normally would:
SELECT [Column1]
,[Column2]
,[Column3]
,[TimeStamp]
FROM [View_1]
WHERE TimeStamp > GETDATE()-730
I get this execution plan:
There is a query executing from an application formatted like this:
SELECT
"Column1"
,"Column2"
,Column3
,"TimeStamp"
FROM "Database".dbo."View_1"
WHERE "TimeStamp" > GETDATE()-730
This gives me this execution plan:
Is there an explanation for why adding the double-quotes changes the plan?
There are no indexes on either table or the view.
1