CREATE PROCEDURE SLOW$LIKE_Int_JOIN_test
@str nvarchar(MAX),
@tookms int OUTPUT AS
DECLARE @start datetime
SELECT @start = getdate()
INSERT Int_JOIN(word)
SELECT u.word
FROM usrdictwords u
WHERE ',' + @str COLLATE Slovenian_BIN2 + ','
LIKE '%,' COLLATE Slovenian_BIN2 + ltrim(str(wordno)) + ',%'
SELECT @tookms = datediff(ms, @start, getdate());
SELECT word FROM Int_JOIN
TRUNCATE TABLE Int_JOIN
go
CREATE PROCEDURE SLOW$LIKE_Str_JOIN_test
@str nvarchar(MAX),
@tookms int OUTPUT AS
DECLARE @start datetime
SELECT @start = getdate()
INSERT Str_JOIN(wordno, guid)
SELECT u.wordno, u.guid
FROM usrdictwords u
WHERE ',' + @str + ',' LIKE '%,' + u.word + ',%'
SELECT @tookms = datediff(ms, @start, getdate());
SELECT wordno FROM Str_JOIN
TRUNCATE TABLE Str_JOIN
go