Re: Adding index for Like operartor

2018-11-28 Thread Jason Huynh
== should in theory be faster. The compiled like eventually boils down to a >= query but it takes a few steps to get there. If I understand correctly. the second approach would be indexed on a string field and the query would look similar to "select * from /region where stringField = 'ABC'" If t

Re: Adding index for Like operartor

2018-11-28 Thread anjana_nair
Thank you Jason. I have one more question related to this. I have two options / object structures for storing and retrieving objects. First one . Storing objects like : {key :"ConstantString_randomString", List objects} and then use queries with like "ConstantString_%" where function index is

Re: Adding index for Like operartor

2018-11-26 Thread Jason Huynh
Key indexes tell the query engine that the field is the same as the key that was used to put into the underlying region. So let's say your field is "ID". Creating a key index tells the query engine that a "select * from /region theRegion where ID = 1" is the same as doing : theRegion.get(1). In

Re: Adding index for Like operartor

2018-11-26 Thread Alexander Murmann
Hi, Have you thought about using the built-in Lucene functionality for this? Fuzzy text search is exactly what it's made for. On Mon, Nov 26, 2018 at 12:15 PM anjana_nair wrote: > > Hi, > > I would like to add an index to key (keyindex) and the query executed is > going to be like > > "constant