Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion Groups
DB Engine
SQL ServerMSDESQL Server CE
Services
Analysis (Data Mining)Analysis (OLAP)DTSIntegration ServicesNotification ServicesReporting Services
Programming
CLRConnectivitySQLXML
Other Technologies
ClusteringEnglish QueryFull-Text SearchReplicationService Broker
General
Data WarehousingPerformanceSecuritySetupSQL Server ToolsOther SQL Server Topics
DirectoryUser Groups
Related Topics
MS AccessOther DB ProductsMS Server Products.NET DevelopmentVB DevelopmentJava DevelopmentMore Topics ...

SQL Server Forum / DB Engine / SQL Server / March 2008

Tip: Looking for answers? Try searching our database.

Plan Guide

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Hurme - 04 Mar 2008 20:11 GMT
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
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2009 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.