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: Monday, June 8, 2015 3:02 PM
Points: 81, Visits: 196
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