Hi,
I have queries below which work like SELECT * FROM table WHERE raw.name LIKE 'Product1*'
. I just want to find out which one would be the best in terms of performance and usability?
Thanks
{"query":{"prefix":{"name.raw":"Product1"}}}
{"query":{"wildcard":{"name.raw":"Product1*"}}}
{"query":{"regexp":{"name.raw":"Product1.*"}}}
{"query":{"bool":{"must":{"prefix":{"name.raw":"Product1"}}}}}
{"query":{"bool":{"must":{"wildcard":{"name.raw":"Product1*"}}}}}
{"query":{"bool":{"must":{"regexp":{"name.raw":"Product1.*"}}}}}
{"query":{"filtered":{"filter":{"bool":{"must":{"regexp":{"name.raw":"Product1.*"}}}}}}}