Home Forums SQL Server 2012 SQL Server 2012 - T-SQL SP with 3 parameters as delimited list - Goal 500 milliseconds RE: SP with 3 parameters as delimited list - Goal 500 milliseconds
John Mitchell-245523
SSC Guru
Points: 148809
More actions
June 30, 2016 at 9:42 am
#1887922
Yes, and consider using a temp table instead of a table variable. The former has statistics on it and so you're likely to get a better query plan, especially if there are a large number of elements in your delimited lists.
John