How fast is the query? You can make it parallel, but if it is sliw, the you
have to target that first.
How big is the set of one user's all urls? How fast is to get this? Maybe
adding some indexes may help
How fast is the query with one pattern only? Maybe combining them into a
"similar to '%
Hi,
I have a query as below which is used for pulling out all the urls accessed
within app.
select name, id, received_at
from users
where (url LIKE '%abc%' or url LIKE '%def%' or url LIKE '%ghi%' or url LIKE
'%jkl%' or url LIKE '%mno%' or url LIKE '%pqr%' or url LIKE '%stu%' or url
LIKE '%vwx
