Hi.
Can someone tell the difference between below ...
# troubleshootingh
harnoor
07/05/2022, 3:33 PMHi.
Can someone tell the difference between below two filters?
text_match(backend_name,'/perf/')REGEXP_LIKE(backend_name,'perf')text_matchREGEXP_LIKE(backend_name,'perf')m
Mayank
07/05/2022, 5:28 PM
@Atri Sharma ^^
h
harnoor
07/08/2022, 6:16 AMHi @Atri Sharma ,
Can u help pls.
a
Atri Sharma
07/08/2022, 6:17 AMLooking within the hour
👍 1
Atri Sharma
07/10/2022, 5:18 PMHi @harnoor, apologies for the delay.
text_match(backend_name, 'perf')Atri Sharma
07/10/2022, 5:18 PMAlso, I am assuming you have text index created on
backend_nameh
harnoor
07/10/2022, 7:09 PMyes text index is created.
I tried
text_match(backend_name, 'perf') Copy code
Select distinct(backend_name) FROM backend_entity_view WHERE regexp_like(backend_name,'perf') Copy code
<http://mock-go.int.perf.in|mock-go.int.perf.in>
perf.cache.np.vpc Copy code
Select distinct(backend_name) FROM backend_entity_view WHERE text_match(backend_name,'perf') Copy code
No Record(s) foundtext_match(backend_name,'/.*perf.*/')a
Atri Sharma
07/11/2022, 6:14 AMAh, so you are not looking to match the term, but the entire document.
So, FST indices will index individual tokens (so you have 'perf' as a token). Whereas the text index will map to the entire document (so what you are saying is that give me any document which has 'perf' as a substring)
Atri Sharma
07/11/2022, 6:15 AMSo for FST index, its a term query, vs for the text index, its a regex query. Note that regex will be a bit more expensive
h
harnoor
07/11/2022, 7:30 PMThanks for the answer.
Regarding the right configuration for speeding up
REGEXP_LIKE()