You need to sign in or sign up before continuing.
Suggested In-Lined User-Defined Function in Structure Database - SDMXRI-1127
Not sure this is the correct place for this ticket, as it requires a change in Eurostat-managed code. We've been doing a lot of load-testing recently and are consistently getting complaints that a UDF is used in the WHERE clause of a SELECT (which forces a total-table scan). The UDF is the dbo.isEqualVersion function, and it seems to be most commonly used on the [dbo].[ARTEFACT] table.
Ideally it should be removed for native SQL.
Edited by Jens Dossé