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

How to improve query with multiple LIKEs with leading wildcards Expand / Collapse
Author
Message
Posted Friday, December 7, 2012 10:53 AM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Friday, December 5, 2014 7:49 AM
Points: 81, Visits: 193
I figured it out! Thanks to this link, I changed all the ORs to UNIONs. My query now runs in less than one second.
Post #1394172
« Prev Topic | Next Topic »

Add to briefcase ««12

Permissions Expand / Collapse