Is it possible to do something like this with a query plan?
I want to get
Query1
select * from tableA
where col1 like '%value%'
to run like
Query2
select * from tableA
where contains(col1, "value")
using a plan_guide.
Basically what's happening is a 3rd party product is executing a query that
looks like query1, which is searching on a text field (col1).
I wanted to try a full text index, but I don't think that I can get the
vendor to change their code to use a contains instead.
Any ideas?
Tia

Signature
MG
Aaron Bertrand [SQL Server MVP] - 04 Mar 2008 20:44 GMT
Egads, why isn't the vendor using stored procedures?
> Is it possible to do something like this with a query plan?
>
[quoted text clipped - 22 lines]
> Any ideas?
> Tia
Mike C# - 06 Mar 2008 22:50 GMT
> Egads, why isn't the vendor using stored procedures?
LOL with SQL statements hardwired into the client-side code the customer
can't go in and make changes like this to the code