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
  • 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 2 at 8:35
  • What change were you expecting? – Martin Smith Jan 2 at 11:41
  • Schema binding how to increase query performance at this example ?? – Mehdi Jan 2 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. dba.stackexchange.com/a/140382/3690 – Martin Smith Jan 2 at 14:12

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.