sqlperformancelinqexecutequery

SQL LINQ executequery is work slow. How can i improve performance?

select top 10 productName 
from Products 
where productDetails like '%something%' 
group by productName
order by productName asc

What should i do/change on my query to improve performance?

Solution

  • Having a query with a clause, <column> like '%<anything>' will cause a table scan to check every single row to see if it matches the clause. Depending on your choice of RDBMS, and your exact requirements, you could look into full text indexing, or if your queries could be rewritten to be <column> like '<something>%', then the query will be able to use indexes on the column.