Home Forums SQL Server 7,2000 General How to write SQL query to find a word in string" RE: How to write SQL query to find a word in string"

  • Check your exectution plan on this one and watch your indexes. Using LIKE with a leading wildcard will result in a table scan if you're not careful. From a high level glance, an index on isEnabled/isPrivate may help things here. It's hard to say not knowing the selectivity of those columns, your table row count, etc. Bottom line is, check your execution plan as this could lead to being a poor performer.

    John Rowan

    ======================================================
    ======================================================
    Forum Etiquette: How to post data/code on a forum to get the best help[/url] - by Jeff Moden