Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase ««12

Like operator - Query performance issue Expand / Collapse
Author
Message
Posted Wednesday, April 2, 2014 12:59 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Sunday, April 27, 2014 7:55 PM
Points: 218, Visits: 556
Dear All

Thanks for your replies. I created full text index but when see the execution plan it does not show the full text index but shows cluster index.


And the query is still slow.


Regards
Krishna
Post #1557341
Posted Wednesday, April 2, 2014 3:38 AM


SSCoach

SSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoach

Group: General Forum Members
Last Login: Yesterday @ 7:32 PM
Points: 15,517, Visits: 27,895
You have to change your code to use the full text index. It's not like a regular index where the optimizer just picks it up. You need to read up on this. Here's an introduction.

----------------------------------------------------
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood..." Theodore Roosevelt
The Scary DBA
Author of: SQL Server 2012 Query Performance Tuning
SQL Server 2008 Query Performance Tuning Distilled
and
SQL Server Execution Plans

Product Evangelist for Red Gate Software
Post #1557382
« Prev Topic | Next Topic »

Add to briefcase ««12

Permissions Expand / Collapse