Hey All,
I am wondering if there is a common pattern for these sort of queries :
SELECT * FROM tbl WHERE datanumber LIKE '%12345%' OR LIKE '%54321%' OR LIKE '%8766%' OR LIKE '%009%', ..
The number of OR/LIKES are in the order of 50-100 items...
the table tbl is a couple of million rows.
The datanumber is a string that are maximum 10 characters long, no spaces and can contain numbers and letters.
Apart from creating a couple of index table to make the LIKE left anchored something like this :
tbl <----> tbl_4letters
tbl <----> tbl_5letters
tbl <----> tbl_3letters
or creating a functional index 'of some sort' are there any other brilliant ideas out there to solve such a problem (GIN/GIS???) ?
Searches are currently taking to long and we would like to optimize them, but before we dive into our own solution we
where wondering if there already common solutions for this...
Kind Regards,
Ries van Twisk