Good morning!!
I hope you all are well , have a problem with the use of an index , I'm using a CONTAINS , the first consultation saves the results , if I add new records to the table on which the index is , this is not me the sample, only shows me the first search you do with the data at that time were on the table.
I appreciate the cooperation and assistance .
Pdta : I apologize for my English
select * from test
Result
text/textid
| Corp. | 1 |
| Goldcorp | 2 |
| Corporation | 3 |
| Corporation | 4 |
| Corp2 | 5 |
| Corp3 | 6 |
| Corp4 | 7 |
select * from test where CONTAINS(text,'%Corp%', 1) > 0
Result
text/textid
| Corp. | 1 |
| Goldcorp | 2 |
| Corporation | 3 |
| Corporation | 4 |
| Corp2 | 5 |