Skip to Content
1
Dec 17, 2013 at 03:18 PM

HANA Fuzzy Search

543 Views

Experts:

My use case is: I want to perform fuzzy search of Names in one table into another table.

Both tables have Thousands of records.

Problem: If i use SQL CONTAINS statment to perform fuzzy search, it takes around 20 ms for one check.

Therefore to check 100K Names, it takes 100000 * .02 = 2000 seconds!! (which is quite high).

What is most performant way to perform fuzzy check with mass data on both sides ?

Thanks & Regards.