0

enter image description here After alter function execution paln did not change. 

Alter FUNCTION dbo.F_New
(
    @i integer
)
RETURNS DateTime
WITH SCHEMABINDING
AS
BEGIN
    -- Convert with a deterministic style


 RETURN CONVERT(datetime, '19000101', 112);
END;
GO
Community
  • 1
Mehdi
  • 1
  • 1
    In the excecution plan posted, you seem to be using the function dbo.F. Could you post the execution plan before and after the change and any other relevant information? Also the execution plan might use different operators, even though you altered the function. Why do you want the execution plan to change? – Randi Vertongen Jan 02 '19 at 08:35
  • What change were you expecting? – Martin Smith Jan 02 '19 at 11:41
  • Schema binding how to increase query performance at this example ?? – Mehdi Jan 02 '19 at 11:54
  • 1
    You already have an optimal plan with a seek. Can you give "before" and "after" versions so we can see what you are testing. I assume this question is about this answer. https://dba.stackexchange.com/a/140382/3690 – Martin Smith Jan 02 '19 at 14:12

0 Answers0