LIKE or CHARINDEX algoritms
From: Kuido K?lm via SQLMonster.com (forum_at_SQLMonster.com)
Date: 02/07/05
- Next message: Hugo Kornelis: "Re: Difference between = and IN"
- Previous message: Phil: "Where Statements"
- Next in thread: Steve Kass: "Re: LIKE or CHARINDEX algoritms"
- Reply: Steve Kass: "Re: LIKE or CHARINDEX algoritms"
- Messages sorted by: [ date ] [ thread ]
Date: Mon, 07 Feb 2005 18:07:44 GMT
Hello !
Does nobody in which algorithm the LIKE and CHARINDEX function based.
Is it meaningful to write itself search algoritms based on
Knuth-Morris-Pratt or Boyer-Moore algoritms to replace LIKE on CHARINDEX
functions for speed exhancement ? (I itself not belive)
Is the some ways to speed up LIKE searches ?
Kuido
-- Message posted via http://www.sqlmonster.com
- Next message: Hugo Kornelis: "Re: Difference between = and IN"
- Previous message: Phil: "Where Statements"
- Next in thread: Steve Kass: "Re: LIKE or CHARINDEX algoritms"
- Reply: Steve Kass: "Re: LIKE or CHARINDEX algoritms"
- Messages sorted by: [ date ] [ thread ]
