Thursday, February 26, 2015

How is it possible to use Index Seek for LIKE %search-string% case?

Lesha if you add OPTION (RECOMPILE) do you get different plan?


Best Regards,Uri Dimant SQL Server MVP, http://ift.tt/1iQ9JkR



MS SQL optimization: MS SQL Development and Optimization

MS SQL Consulting: Large scale of database and data cleansing

Remote DBA Services: Improves MS SQL Database Performance

SQL Server Integration Services: Business Intelligence


No comments:

Post a Comment