بهبود عملکرد استفاده از Temp Table با استفاده از Function در دیتابیس

CREATE TABLE #TmpTable
	(
		Id INT NOT NULL
	);

IF (@MarketIds IS NOT NULL)
	BEGIN
		INSERT INTO #TmpTable
           SELECT value
           FROM STRING_SPLIT(@CustomId, ',');
     END

WHERE (@MarketIds IS NULL OR (S.MarketId IN (SELECT Id
                                             FROM #TmpTable)));

CREATE FUNCTION [dbo].[FnStringToTable](
    @InputString Varchar(max),
    @SeparatedChar CHAR(1)
)
    RETURNS @Table TABLE
                   (
                       ColumnData VARCHAR(100)
                   )
AS
BEGIN
    IF RIGHT(@InputString, 1) <> @SeparatedChar
        SELECT @InputString = @InputString + @SeparatedChar;

    DECLARE @Pos BIGINT,
            @OldPos BIGINT
       SELECT @Pos = 1,
           @OldPos = 1;

    WHILE @Pos < LEN(@InputString)
        BEGIN
            SELECT @Pos = CHARINDEX(@SeparatedChar, @InputString, @OldPos);

            INSERT INTO @Table
            SELECT LTRIM(RTRIM(SUBSTRING(@InputString, @OldPos, @Pos - @OldPos))) Col001;

            SELECT @OldPos = @Pos + 1;
        END

    RETURN
END
GO

 SELECT * FROM
	dbo.MyTable AS m WITH (NOLOCK) LEFT JOIN
     dbo.FnStringToTable(@CustomId, ',') AS s ON m.CategoryId = s.ColumnData