Timeline for Performance issues in parameterized queries accessing a view in SQL Server
Current License: CC BY-SA 4.0
2 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Feb 5 at 16:19 | comment | added | jkohl | I have directly tried it in my small example case and adding the include did not change anything for me. The query is still doing a full table scan. But I also see that even before the change of the index in your fiddle the SQL server already did an index seek plus an additional RID lookup which would be already good enough in my case. But I end up with a full table scan instead. | |
| Feb 5 at 14:44 | history | answered | Charlieface | CC BY-SA 4.0 |