sql server - How to overcome ( SQL Like operator ) performance issues? -


i have users table contains 500,000 rows of users data

the full name of user stored in 4 columns each have type nvarchar(50)

i have computed column called userfullname that's equal combination of 4 columns

i have stored procedure searching in users table name using like operatior below

select *  users  userfullname n'%'+@fullname+'%' 

i have performance issue while executing sp .. take long time :(

is there way overcome lack of performance of using operator ?

not while still using operator in fashion. % @ start means search needs read every row , match. if need kind of search should using full text index.


Comments

Popular posts from this blog

Capture and play voice with Asterisk ARI -

java - Why database contraints in HSQLDB are only checked during a commit when using transactions in Hibernate? -

visual studio - Installing Packages through Nuget - "Central Directory corrupt" -