Finding the Best Match With a Top-N Query

(Markus Winand) There was an interesting index related performance problem on Stack Overflow recently. The problem was to check an input string against a table that holds about 2000 prefix patterns (e.g., LIKE ‘xyz%’). A fast select is needed that returns one row if any pattern matches the input str

Read More - Register for Free Membership