Assuming multiple application servers are deployed is it okay that each one runs Search Service and Search Indexing Service?

Hello everyone,

I see in the official documentation that I can create new index using the schema extension tool. But I have two questions?

1. Could this index create directly in the database?
2. One Identity allow create new Clustered index?

Thank you…

The index-based search returns results for substrings only if they are at the beginning of a word (see table).
It is expected that the index search will also yield results if the search string is within a word. Analogous to the SQL search with like '%…