I have a table with about 10,000 rows.
I imported about 2000 rows into this table last week. All seemed to be going fine, however when I try to search for these new items using the simple syntax:
SELECT * FROM FreeTextTable(tablename, columnname,'search_string')
It only seems to return results from before the import.
Could the index be full, or could something have stopped sql from indexing further?