SQL Server 2022

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

CREATE FUNCTION dbo.fn_calcIncome 
(
)
RETURNS int
with schemabinding
AS
BEGIN
	RETURN 50
END
CREATE TABLE foo
(
    id int, 
    name varchar(100),
    calcIncome AS dbo.fn_calcIncome() 
)

CREATE INDEX IX ON foo(calcIncome)
select calcIncome 
from foo WITH (FORCESEEK)
where calcIncome = 50
Msg 8622 Level 16 State 1 Line 1
Query processor could not produce a query plan because of the hints defined in this query. Resubmit the query without specifying any hints and without using SET FORCEPLAN.