Is there any DB index that can improve query performance like% keyword%?

Question

I know that indexing in a text box can help with a search using like 'keyword%' .

But is there any cross-database that can improve full-text search with like '%keyword%' ?

In general, for text fields with less than 1000 characters, when does query performance like %keyword% become unacceptable for a web query? Tell me when the table reaches 10K rows?

Answer 1

You can use FULLTEXT INDEX and browse using certain commands - in MSSQL you can use CONTAINS (column, '* keyword *) or FREETEXT - https://msdn.microsoft.com/en-us/library/ms142583.aspx

As for your performance question, it is highly related to your infrastructure, your data, or your search terms.