Hello,
I've created a table with StringCol and I'd like to make my contains() operator use index I created on it. It seems like an index is working, because:
print doctable.will_query_use_indexing("""W == 'variable'""")
results in: frozenset(['W']).
But:
print doctable.will_query_use_indexing("""contains(W, 'variable')""")
results in: indexing? frozenset([])
So while the query like this one works and returns expected results, it probably does not use indexes:
n = [x['W'] for x in doctable.where("""contains(W, 'variable')""")]
Is there a way for me to make "contains()" use an index just like "==" operator seems to use it?
Regards,
mk