I have a query as follows:
select top (30000) * from table1 where licenseplate like '%as43bv%'
I have an index on
licenseplate but the query will not hit the index due to leading wildcard.
Since the column queries license plate numbers full text search wont come to any benefit we are searching on some letter or number rather than words
The above query fetches millions of rows and brings the CPU usage around 100%.
Is there any efficient way to rewrite the query and make use of the indexes.