Is it a possibility that full-text indexes will be eventually added to certain columns in the Data Explorer? I perfectly understand that SO servers are under a heavy load, and this would add significantly to disk use, but on the other hand, full-text queries are more efficient once the index is built and maintained. Text querying is a very powerful tool, and, given that, for one, regular SO search does not index comments, would be the to-go way for searching in them.
Currently, an attempt to use the
FREETEXT() T-SQL predicates on
comments.text results in an error:
select top(100) id [Comment Link], text from comments where freetext (text, 'attribute package') order by score desc
Cannot use a CONTAINS or FREETEXT predicate on table or indexed view 'comments' because it is not full-text indexed.
Was this feature considered? And if it was, is it planned? A question about one of the predicates came up last time in 2014 (and was only incidental, stemming from an incorrect attempted use of
CONTAINS instead of
LIKE), so I think it would not be too much of a nuisance to ask about it specifically.