In SQL Server 2008 R2 I have a query which looks like
create stored procedure give_me_art @filter varchar(15),@skl_id int begin select id,naziv,sifra,isnull(lager.kolicina,0) as lager from art left outer join lager on art.id=lager.art_id and lager.skl_id=@skl_id where sifra like '%'+@filter+'%' or naziv like '%'+@filter+' end
I have an index on column naziv and column sifra.
I am considering changing this query to full text search. Table art has around 150K records and my main goal is to get faster response from SQL Server, because this query is common during daily work.
If I make a full text index on these two columns and redesign my query to use the full text index, what will happen with performance of this query?