eywek
08/18/2021, 10:20 AMorder
statement:
• When I’m doing this query:
select * from datasource_607ec7451360000300516e33 where REGEXP_LIKE(url, '^.*tv.*$') limit 10
only 240 docs are scanned and I get a reply in 20ms
• When I’m adding an order:
select * from datasource_607ec7451360000300516e33 where REGEXP_LIKE(url, '^.*tv.*$') order by "timestamp" desc limit 10
547 212 docs are scanned and I get a reply in >1.5s
Do you have any ideas/tips to improve this?Cristian Osiac
08/18/2021, 10:23 AMeywek
08/20/2021, 9:07 AM