We have an index on one of our fields that was created in this manner:
tsql -q "set keepnoise='on';set delexp=0;set addexp='\punct{1,5}';set addexp='\a
lnum{1,99}';set addexp='>>\alpha{1,50},=\alpha{1,50}';create metamorph inverted
index.........
When we run a search for something along the lines of "select * from mytable where myfield like 'a-6253'" it takes a long time to return. Linear search times.
I took the liberty querying against the index above, and in the Word column I saw entries for "-", for "a", but not for "6253". I assume its absence is the reason the search takes so long? If so, would you know by chance why it's not in the index? We're using Texis version 4.04.1067366033 if it helps to know. Thanks!
tsql -q "set keepnoise='on';set delexp=0;set addexp='\punct{1,5}';set addexp='\a
lnum{1,99}';set addexp='>>\alpha{1,50},=\alpha{1,50}';create metamorph inverted
index.........
When we run a search for something along the lines of "select * from mytable where myfield like 'a-6253'" it takes a long time to return. Linear search times.
I took the liberty querying against the index above, and in the Word column I saw entries for "-", for "a", but not for "6253". I assume its absence is the reason the search takes so long? If so, would you know by chance why it's not in the index? We're using Texis version 4.04.1067366033 if it helps to know. Thanks!